By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Selecting a specific row in a Combo Box

P: 1
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.
Dec 8 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
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).
Dec 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.