fill a field based upon the answer of another

[rexrivas]

I have a form that includes a field that has trhe following propoerties SELECT [Vendor].[Vendor Name], [Vendor].[Vendor Nbr] FROM Vendor ORDER BY [Vendor].[Vendor Name];

How can i the the vendor nbr to populate a field called vendor number based on the selection of vendor name

 

[PHV]

Take a look at the FAQs, noticely those related to combo

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884