I have a huge problem going on for 2 weeks, I am trying to get my ComboBox selection to look at 3 different fields for a match and fill in the TextBox controls with those records in a SubForm.
Can someone explain the VBA needed to get a ComboBox to look at multiple fields for a match?
Example:
Main Form - ComboBox selection is "Bat"
Table:
Field1 = Glove
Field2 = Bat (matched)
Field3 = Ball
The CB selection could be in any one of the 4 fields.
Thank you
Can someone explain the VBA needed to get a ComboBox to look at multiple fields for a match?
Example:
Main Form - ComboBox selection is "Bat"
Table:
Field1 = Glove
Field2 = Bat (matched)
Field3 = Ball
The CB selection could be in any one of the 4 fields.
Thank you