Set Up: I have three different departments that use respective forms I've built to track their new business. These forms are not the same, only some parts are, and so i have 3 separate forms in my database to accommodate the differences (Yes I have normalized my database). To add a new customer as they're doing their data entry, I have an Add Customer button that opens an "Add New Customer" form. My question is - is there a way, on the on-click event of the Add New Customer save/close button, to then update the combobox on the form they also have open at that time so that they do not need to refresh the New Business form to update the combo box and continue on working? I tried the code below - which worked - but only for one form. So I'm not sure if there is a way to update the code to apply to all forms or if I should have an individual Add New Customer form for EACH new business log? Thoughts?
Private Sub btnAddCustomerSaveandClose_Click()
Me.Refresh
Forms!F_CLNBLog.Form.cboCLNBCustomerName = Me.CustomerID
Forms!F_CLNBLog.Form.cboCLNBCustomerName.Requery
DoCmd.Close
End Sub