Syntax referencing the first row from a recordset in an If Then clause

[LowBrow]

I want to build the following statement

If rstQuery.RecordCount > 0 then
frm.dayspaid = "1"
ElseIf
[the first row from rstQuery] = [the current record of frm] then
frm.dayspaid = "1"
Else
frm.dayspaid = Null

But I cannot find the proper syntaxt for naming or referencing the first row
of the recordset. Is there a way?

 

[bradmaunsell]

Have you tried this?

IF rstQuery.BOF or rstQuery.EOF Then
rstQuery.movefirst
.......
Else


and then (if record exists), you can reference the fields with their names or numbers like rstQuery!CompanyName etc