automatically create new record

  • Thread starter Thread starter Duck
  • Start date Start date
D

Duck

I know there must be a very simple solution to this problem, but all I
want is to have a bound form to open ready to create a new record in
the underlying table instead of displaying the first (or any) record
from the table. I don't want my users to have to tell the form that
they want to generate a new record. It's a sales form and all records
are new records.
 
Just change the form's Data Entry property value from default No to Yes.
The form will then open in a new record, as well as prevent users from
browsing existing records.

HTH,
Nikos
 
Open the form and set the Data Entry property to Yes.

--
Joan Wild
Microsoft Access MVP





- Show quoted text -
Click to expand...

Thank you both...I knew it had to be something very simple
 

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

Access Automatically Send a notification email once a record is added 0
Skip Records on a Form 2
Skip Records in a Form 2
Continous Forms and preventing a new record being created 2
Auto create of new record when accessing subform 3
New Record 4
Data Entry Form and Auto Number ID 2
Calculating a value for a new record 2

Back
Top