Displaying Data in a Form

  • Thread starter Thread starter Marsh
  • Start date Start date
M

Marsh

Using Access 2007, we have a form that has 14 controls bound to fields in a
table.
What we need to do find a method where a user picks a value from a ComboBox
which is one of the 14 above mentioned controls, and have the other controls
populated with the appropriate data.
A simplistic example is to have a combo box with last names, and when Smith
is chosen from the drop down 9 records with the last name Smith are
available in the form. I can then navigate through the various Smiths and
find the First Name, Address, City, State, Zip, etc for any of the Smiths.
Thanks in advance for any suggestions
Marsh
 
Thank you very much - that was easy once I figured out where to put the
Me.Requery code. I am not even a VBA novice.
 
Back
Top