Hi Richard,
Much thanks for the reply and explanation

What you're saying makes sense.  I did not know whoever that on close property on works if the form is open.  Makes sense but I never thought about it since I don't use it much.  In any event, that's not a problem.

I have replicated your method and I got it working just fine in my database.  I think we're miscommunicating.  Here's my scenario that I failed to explain.

I have a sports database.  There's a customer table and continuous form.  
I also have 4 other tables (football, basketball, baseball, soccer).  All 4 of these forms have a combobox named "cboCustomer" that is properly linked to my customer table.

I have tested the tip in your video in the football onclose event and it works great.  I click "add customer" and I the customers form pops up, I enter them in, and when I close it, that customer shows up in the customers combo box in the football form.

My question is, can I replicate this trick in the other 3 forms? Yes I realize I can only have them open on at a time and that's perfectly fine.

This is why I attempted to test with for statements.

Again, here's how I did it and it works.  The code below is coded in the customer table in the OnClose Event:
Private Sub Form_Close
Forms!frmFootball!cboCustomer.Requery
End Sub

I was attempting to add these:
Private Sub Form_Close
Forms!frmBasketball!cboCustomer.Requery
Forms!frmBaseball!cboCustomer.Requery
Forms!frmSoccer!cboCustomer.Requery
End Sub

Thanks again for all your help and hopefully I have explained it better this time around.

---

Reply from Richard Rost:

Use ONE table and ONE form for all four sports. Have a FIELD that indicates which sport it is.