So far this is as simple as it is.....
Private Sub AddNewCustomer_Click()
On Error GoTo Err_AddNewCustomer_Click
Dim stDocName As String
stDocName = "frmSubCustomerByName"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd
Exit_AddNewCustomer_Click:
Exit Sub...
Sorry, but your reply does not help. Reset the property to what? The current source is a query how do I trap for reruning that query when I come back to the product form?
I have 2 forms. Once is a form for entereing customer info and the other is for entereing products. When on the product form, there is a combo box that list the customers to select from. But the customer I want is not listed in the combo box. I have a button on the product form called "Add...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.