Unanswered: Event Procedure - On DBL Click - Open Form - Basic Help
Greetings Everyone or Anyone,
What is the best "Event Procedure" code to put in a form's combo box "On Dbl Click" event which will open another form.
Basically, on frmOrders there is a customer combo box. If the customer is new and does not show up in the combo box list then the user needs to double click on the combo box to open frmCustomers and add the relative data. After closing the frmCustomers the combo box list on frmOrders should now show the newly created customer.
I tried different variations of the following code but nothings works right:
DoCmd.OpenForm "frmCustomers", , , , , acDialog, "GotoNew"
It does not open frmCustomers as "GotoNew". Also, after adding the new record and closing frmCustomers the combo box list in frmOrders does not contain the newly added customer. Looks like the combo box needs to be refreshed.
This is what Iam looking for in English:
1. Open frmOrders to create a new order
2. Select the Customer from a combo box list
3. If Customer is not listed then dbl click on combo box to
Open frmCustomer, add new, and close frmCustomer
4. Select the newly added customer in the combo box