Displaying Data in a Form

[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

 

[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.