Open form in Add mode

G

Guest

Sometimes when in the middle of completing the input on a form, users find
they need to pause and add a new record to one of the tables - for example, a
shipping agent.
I have provided a cmd button (Add Agent) that opens the agent form and a
Close btn to take them back to the original form they were in. Fine.
However, the secondary form always opens already populated with an existing
record whereas for this particular usage I want it to be blank for adding a
new one.
I don't want to code something that will ALWAYS make it open in Add mode,
because the same form is used elsewhere for editing and maintaining the agent
records. It's only when fired from this particular button that I want it to
be in Add.
Thanks for your suggestions!
CW
 
G

Guest

In the open form command line you can specify how to open it

Docmd.OpenForm "FormName" , , , ,acFormAdd

acFormAdd, will make it to open as data input, remove it and it will open as
always

Docmd.OpenForm "FormName"
 

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 for record selected in combo 2
Open another form in Add mode 2
Open 2nd form in Add Mode with a value taken from 1st form 5
I am trying to add a sub-form, but the button is disabled? 1
Open Form in Add Mode 1
Open for to Edit or Add Record 6
Access MS Access: Autofill Textbox Data In Form will not Save Data To Table 0
Open read-only form blank 2

Top