Open form for add/edit records

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I have a button on the main form:

DoCmd.OpenForm "frmEmployee", acNormal, , , acFormEdit, acWindowNormal

I can still add record by clicking the * on the record selector.
So what is the difference:
DoCmd.OpenForm "frmInvoice", acNormal, , , acFormAdd, acWindowNormal ?
 
Depends on what you want to do. If you don't want users to add any records
then set the form to read only (is also one of the options).
 
The difference is that acFormEdit allows editing AND adding of new records
(as you've found out) while acFormAdd ONLY allows adding new records, just
as setting the Dtat Entry Property to YES would.
 

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

Form records has only 1 but should have many 1
Set form's property when opening it 5
OpenForm 8
Open form with arguments - invalid use of NUL: 8
stopping an unwanted requery 1
Datasheet view 2
Second form appears behind the first 2
Insert CLientID into popup form 1

Back
Top