Rst.FindFirst does not always work.

[pedie]

Does Rst.findFirst only look the first row/record in table?
It always return does not match.

Thanks in advance.

 

[Norie]

Pedie

How are you using it?

 

[pedie]

Pedie

How are you using it?

Hi Norie,
my current code looks like this.
I'm checking if record with current user id exist.
I do not want to loop though to check if it exist rather just quickly find it.

Thanks in advance.

[/FONT]
[FONT=Courier New]Option Compare Database
Option Explicit[/FONT]
[FONT=Courier New]Sub Test1_findFirst()
Dim rst As dao.Recordset
Dim MYXID As String[/FONT]
[FONT=Courier New]MYXID = UCase(Trim(Environ("Username")))[/FONT]
[FONT=Courier New]Debug.Print MYXID
Set rst = CurrentDb.OpenRecordset("EMPINFO", dbOpenDynaset)[/FONT]
[FONT=Courier New]rst.MoveFirst
rst.FindFirst rst!IDS = MYXID
If rst.NoMatch Then
 Debug.Print "no match"
Else
 Debug.Print "Match"
End If
rst.Close
Set rst = Nothing
End Sub

 

[Norie]

The criteria is wrong.

I think it might be this, but I'm not sure.

rst.FindFirst "IDS = '" & MYXID & "'"

PS Why are you using rst.MoveFirst?

 

[pedie]

The criteria is wrong.

I think it might be this, but I'm not sure.

rst.FindFirst "IDS = '" & MYXID & "'"

PS Why are you using rst.MoveFirst?

Norie, perfect!
Well i was just using 'rst.MoveFirst" thinking that it might be trying to find in some other records like last records etc

Thanks Norie