Open another form in Add mode

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
 
O

Ofer Cohen

Use acFormAdd in the OpenForm command line to open the form in Add record state

Docmd.OpenForm "InvoiceCreate",,,,acFormAdd
 
C

CW

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
 

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