Open another form in Add mode

  • Thread starter Thread starter CW
  • Start date Start date
C

CW

On my Orders form I want to have a command button that will open my
InvoiceCreate form in Add mode, so that I can build a new invoice.
The Command Button Wizard includes opening a form but only if you link a
field or display all records - it doesn't seem to provide the option of
opening a form empty in order to add a new record.
Could somebody please provide some code for this?
Many thanks
CW
 
Use acFormAdd in the OpenForm command line to open the form in Add record state

Docmd.OpenForm "InvoiceCreate",,,,acFormAdd
 
Got it - works fine
Many thanks
CW

Ofer Cohen said:
Use acFormAdd in the OpenForm command line to open the form in Add record state

Docmd.OpenForm "InvoiceCreate",,,,acFormAdd
Click to expand...
 

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

Push values into linked new form 1
Open form in Add mode 1
Access Automatically Send a notification email once a record is added 0
Open a form in ADD mode 2
Add new record through Form view 4
Open Form in Add Mode 1
Separate Form 0
trouble using button to open new form to add new record 1

Back
Top