recordset query to multiple records
Posted on 2000-02-20
I have a table in access that consists of three columns.
column headings: Heading,Key,SupplierKey
I open a recordset from my form to select * from table WHERE SupplierKey = "something"
This recordset fills up a combobox
When I select an item in the combobox, I want the recordset to move to a record in the recordset where the combobox.text returns the value of recordset!Key (this will be the value for text1.text)
How do I do this. Please help!
I thought about INNER JOIN, but I don't want to join two tables.
The 'Heading' column can have the same value e.g Keyboards, but the 'Key' column identifies which record I want.
The reason I am selecting records from the 'SupplierKey' column to open the recordset, is because this is being selected from a different combobox.
Thanks for the answer!!!