Opening a Form to a New Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i make it so that when my form opens it goes directly to a New Record?

Thanks in Advance
Travis
 
Open the form in design view and set the Data Entry proterty to Yes.

You will not be able to view records with this form.
 
Depends on whether you always want to add a new record, or you also need to
be able to see existing records.

If the former, set the Data Entry property of the Form to Yes. If the
latter, in the OnOpen event property of the form choose Event Procedure and
use

DoCmd.GoToRecord , , acNewRec
 
You must log in or register to reply here.

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

Similar Threads

Record-Locking remains open after closing 0
startup 6
Form to select a Record 2
Printing a single Record in a Report 1
Skip Records in a Form 2
Scrolling in a form 1
change the default opening of a form to enter a new record 2
Open form based on selection 5

Back
Top