Combo Box in a Form

[j3andc]

I have a form with 16 different fields to be populated. I want to use a combo box for 4 of them. I was able to set up only 1 that would refresh its data after entering new data. The set up the other three exactly the same.

I am using the following code:

Private Sub Form_Current ()
Me."My data".Requery
End Sub

where "My data" = the name of the field.

I then duplicated this for all 4 of the combo boxes. It still only works for the first one. Any assistance would be greatly appreciated.

Jim