Forum Discussion

Brass Contributor

Oct 15, 2024

FindFirst not working

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] = "...

access

office 365

arnel_gp

Iron Contributor

Oct 16, 2024

Maxine14062 , maybe set your recordset like this:

Set rst = CurrentDb.OpenRecordset("SchedFieldTable", dbOpenDynaset)