Getting a form to open at new record

  • Thread starter Thread starter Seamus
  • Start date Start date
S

Seamus

I have a form opening at startup. I would like to have
this form immediately go to the new record position. I
know that the shortcut to do this is <Ctrl> + +, but is
there a way to make it happen automatically?

Thanks,
Seamus
 
Seamus said:
I have a form opening at startup. I would like to have
this form immediately go to the new record position. I
know that the shortcut to do this is <Ctrl> + +, but is
there a way to make it happen automatically?

Thanks,
Seamus

Set the form's Data Entry property to Yes
 
If all you want is a new record, set the form's DataEntry property to Yes.
 
Setting the DataEntry property to Yes won't allow you to navigate back to
previously existing records. If you want to be able to do that, put the
following code in the form's Open event:
DoCmd.GoToRecord,,acNewRec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top