FindFirst syntaxt

[reburton]

I can't seem to figure out the proper syntax for the FindFirst method. I am using several variations of this effort:

Dim dbs As dao.Database
Dim rst As dao.Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblInvoice", dbOpenDynaset)
rst.FindFirst "rst!ID = frmInvoice!txtID"

I get an error message that says that Access doesn't recognize rst.ID as a valid field. But, it most certainly is. I tried substituting tblInvoice but got the same error. What am I doing wrong?

 

[pr2-eugin]

Try..

rst.FindFirst "ID = " & frmInvoice!txtID

 

[pbaldy]

And way more efficient:

Set rst = dbs.OpenRecordset("SELECT * FROM tblInvoice WHERE ID = " & frmInvoice!txtID, dbOpenDynaset)

though that doesn't look like a valid form reference:

http://www.mvps.org/access/forms/frm0031.htm

 

[reburton]

Thanks! That did it, but I wish I had a better handle on the syntax of the commands. Nothing I have ever read or seen in the VBE has ever suggested stringing together a line like that. Any suggested reading or anything? :banghead: