Form opening to new record

[Jim]

I have a form that opens to a new record. I want the form to open to the
first record. I've tried some of the code posted here, such as
docmd.gotorecord,,acfirst, but it's not working. Any suggestions?
Thanks,
Jim

 

[Marshall Barton]

I have a form that opens to a new record. I want the form to open to the
first record. I've tried some of the code posted here, such as
docmd.gotorecord,,acfirst, but it's not working. Any suggestions?

Check the form properties AllowEdits and DataEntry. Or
maybe you are opening the form with the DataMode argument
set to acFormAdd.

 

[John W. Vinson]

I have a form that opens to a new record. I want the form to open to the
first record. I've tried some of the code posted here, such as
docmd.gotorecord,,acfirst, but it's not working. Any suggestions?
Thanks,
Jim

Check the form's Properties, and make sure that the "Data Entry" property is
set to No. If it's Yes, the form will indeed open to the new record and
conceal any existing records.

 

[Jim]

I changed data entry to no and it's working the way I want it to now.