Selecting a specific row in a Combo Box

[CraigIsLostAgain]

I am a novice to Access, but not stupid.
However, I have a database including LastName, FirstName,Date (of visit), etc. and record number. When I use the ComboBox to select a record (in the Header), it always chooses the first record (FindFirst). I want to be able to click on a record (based on date or name(s) and date) and have it fill the Form for editing with that record, not the first one.
How do I do that?

Example:
Adams - Bob - 1/1/2006 - ordered chicken - 1
Adams - Bob - 2/3/2006 - ordered meatloaf - 2
Adams - Tim - 2/5/2006 - ordered lasagna - 3

When I select "Adams" the 'chicken' record shows up, no matter if I click on it or on either the 'meatloaf' record or the 'lasagna' record.

I want the Form to display the record I click on in the ComboBox.

Thank you.

[NeoPa]

You need your ComboBox to return a value which uniquely identifies the record selected.
Perhaps in your case you could display the relevant data and return the RecordNumber as the value. Then you have to link the subform on the RecordNumber rather than the name(s).