Use Combobox to navigate records
Posted on 2004-09-14
Here is my question,
I have a table with a related form. The key data fields are vendor, distribution method, and year. There is a vendor combobox that is unbound to the table that has the vendor names. There is a distribution combobox that has 3 choices (retail, mail, specialty). Each vendor/distribution combination can have different deal years: generally it will be year's 1-3. The vendor combobox is unbound but there is textbook on the form that is bound to the table. The textbox is vendorid which is tied to the vendor name.
For the user of the form:
If the user selects a specific vendor using the vendor combobox, I want Access to first check if there is a a record for that vendor with whatever distribution (mail, retail, or specialty) method is selected on the distribution combobox. If there is I want tthe table to go to year 1 of the vendor/distribution combination.
If the user selects a specific distribution method using the distribution combobox, I want Access to first check if there is a a record for that distribution method with whatever vendor that is selected on the vendor combobox. If there is I want tthe table to go to year 1 of the vendor/distribution combination.
Is this possible?