Finding the right record with a drop down list

[Phil]

My table is a history of tools borrowed. When a tool is returned I want to
select it from a drop down box to bring up the record. The same tool is
borrowed multiple time so it exists in the table multiple times. My drop down
box contains two fields, the other one being the date borowed. It is sorted
so the most recent date is first. However, when I select the record I want
it always returns the first record in the table for that tool, not the one I
selected. How do I correct that?

Thanks.

 

[Jeff Boyce]

Phil

I'm not clear on what your form is displaying...

I can imagine a form that uses an unbound combobox to allow selection of
items (e.g., tools). That combobox would be based on a query that gets
tools from a table that only contains tools, not from a table that contains
records for each time each tool was borrowed.

In the AfterUpdate event of that combobox, the form's source would be
requeried, to display a record about the tool selected. If you are saying
that the wrong "borrowed" record shows up, can you sort or filter the query
that returns the "borrowed tool record?"

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/