Open Form and show records based on Autonumber

[neepshed]

Hi. I want to open a form based on the result of an autonumber for a newly added record.

The form I want to open will be a data sheet with no rows as the autonumber value will not be present in the table.

I have tried DoCmd.OpenForm "frmAssignments", , , "LessonID = AutoNumber"

But it doesnt seem to do what I want.

Any ideas anyone?

Thanks.

 

[JerryKlmns]

DoCmd.OpenForm "frmAssignments", , , "LessonID =" & TheAutoNumberHere

Better post in forum702 or forum705