Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Forms
Trying to Escape
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Guest, post: 3322540"] One approach would be to do away with the CmdAdd button by handling the creation of new customers in the combo's NotInList eventHandler. The code for the event would look something like If MsgBox("Do You Wish to set up a new Customer", vbYesNo) = vbYes Then DoCmd.OpenForm "frmCustomer", , , , , acDialog, cmbCustomer.Value Response = acDataErrAdded Else cmbCustomer.Undo Response = acDataErrContinue End If Note that the value of the comboBox is passed to the form in the OpenArgs parameter so that it can be preset into the appropriate text box without the user having to retype it. Hope This Helps Gerald Stanley MCSD [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Forms
Trying to Escape
Top
