form to generate value from table based on other values entered



Hello. I have a table with three columns (zip code, branch location and
vendor). I am trying to create a form for employees to use to select the
correct vendor based upon the zip code and branch location fields. I'd like
them to be able to select the zip code and branch location from combo boxes
on the form and have the vendor box automatically generate the vendor they
should use from the table already created. Is this possible?

Thanks for any help!




Try this query that uses the combo boxes on your form --
SELECT [Vendor]
FROM [VendorTable]
WHERE [zip code] = [Forms]![VendorForm]![Zip] And [branch location] =

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question