Form opening to new record

J

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
 
M

Marshall Barton

Jim said:
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?
Click to expand...


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

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
Click to expand...

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.
 
Top