Hi. I'm using access 2010 and I watched your YouTube video: "Microsoft Access Add item to Combo Box".

First, thanks for an amazing video and tutorial.
I have replicated your procedure and it works great.
However, I have multiple forums that have customers. For example:
I have a customer table and customer form.
There are 4 other tables/forms that I pick a customer from the drop down. So I tried your method on the close event when I point the line of code to that 1 form. I found out it didn't work for me to do the following:

Private Sub Form_Close
     Forms!frmCustomer1!cboCustomer.Requery
     Forms!frmCustomer2!cboCustomer.Requery
     Forms!frmCustomer3!cboCustomer.Requery
     Forms!frmCustomer4!cboCustomer.Requery
End Sub

I also tried 4 different private subs for kicks and giggles but I knew that wouldn't work

Any idea how I can make it work for all 4 forms. Only one form will be opened at a time if that matters.
Or is the not in list event my only choice in this scenario

Thanks again!

---

Reply from Richard Rost:

Why are you trying to requery the combo box after the form is closed, or on the other closed forms? You don't seem to understand how a combo box works. The combo box does not store data. A combo box is (preferably) bound to a table, which means that it's showing the data that's stored in the table AT THE TIME THE FORM IS LOADED. When you issue a requery, you're saying "go back to the table and get me an updated list of records." In my tip video that you mentioned, one combo box is used as a criteria to FILTER the results in the 2nd combo box, but the boxes themselves don't store any data, nor can you refer to them in code when the forms they're on are closed. I cover combo box basics in Access Beginner 8.