I have a combo box on my enter new contract data form. When the user goes to the form they search by a vendor name to popoluate the vendor name and vendor number into the data entry form. I would like to have the ability to search by vendor name and vendor number. However, it seems I can't do both? They are fields in the same table. Is this a possibility or not?
SELECT Vendor.[Vendor Name], Vendor.[Vendor No] FROM Vendor WHERE (((Vendor.[Vendor Name])<>Nz(Form![Vendor Name],1)));
Vendor name is column 1 and vendor number is column 2.