Open form for add/edit records

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 ?
 
M

Maurice

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).
 
M

missinglinq via AccessMonster.com

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

Top