 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2007Open another form in Add mode
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  SignatureGood Luck BS"D > 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. [quoted text clipped - 4 lines] > Many thanks > CW Got it - works fine Many thanks CW > Use acFormAdd in the OpenForm command line to open the form in Add record state > [quoted text clipped - 8 lines] > > Many thanks > > CW |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.