Form Start from new record

[cwpryor]

Hi

here is an overview of my database = i have 9 fields that are filled upon a pass being given out and 4 that are filled on a pass being returned,

i would like my form to open with a new entry, but i also need it to be able to go back through old records so that the 4 fields can be completed once a pass has been returned.

how do i do this? im fed up with the form always starting at record number one

[Bob Fitz]

Put the following line of code in the form's On Open event

DoCmd.GoToRecord , , acNewRec

[cwpryor]

Thanks! Found a way to work it!