I have a 365 database with the following code:

Set rst = CurrentDb().OpenRecordset(“SchedFieldTable”)

mFID = DLookup(“[FID]”, “SchedFieldTable”, “[Width]+[Left] > 10.5 * 1440”)
MsgBox “[FID] = ” & mFID
rst.FindFirst “[FID]= ” & mFID 

where FID, Width, and Left are all number fields in the table SchedFieldTable. The message box result is: [FID]=25, which is correct.

I get an error on the line:

rst.FindFirst “[FID]= ” & mFID

I have also tried: rst.FindFirst “[FID]= ‘” & mFID & “‘”

Can you help? This is driving me nuts!!!

​I have a 365 database with the following code:Set rst = CurrentDb().OpenRecordset(“SchedFieldTable”)mFID = DLookup(“[FID]”, “SchedFieldTable”, “[Width]+[Left] > 10.5 * 1440”)MsgBox “[FID] = ” & mFIDrst.FindFirst “[FID]= ” & mFID where FID, Width, and Left are all number fields in the table SchedFieldTable. The message box result is: [FID]=25, which is correct.I get an error on the line:rst.FindFirst “[FID]= ” & mFIDI have also tried: rst.FindFirst “[FID]= ‘” & mFID & “‘”Can you help? This is driving me nuts!!!   Read More

​