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

Open form in "Filter By Form" mode 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
Open Form in Add Mode 1
Push values into linked new form 1
Add new record through Form view 4
add new record based on selected record 1
Open form in Add mode 1

Top