form to generate value from table based on other values entered

[Samantha]

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!

 

[KARL DEWEY]

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