Rost,

I am in the mist of making a vendor's form.  Each of our vendors has multiples property location and units numbers inside a dorm or office building.  When I make a List Box on my Vendor form, how will be able to enter different locations or units number without going back into the table and to add them as they come in. So, this means I don't have all the location or units # until they come in for repairs.

Please Note:  Some vendors add new properties locations all the time in total different areas.

I have created 3 tables: Wooten Appliance Vendors Location, Wooten Appliance Vendors Units Properties Table and Wooten Appliance Vendors table of all our Venders. How should I set up the Row Source in the Property Sheet?

This is what I have in the Row Source in the Property Sheet: SELECT LocationID, LocationName FROM Vendors Location WHERE CustomerID=Forms!Vendors Form!CustomerID ORDER BY LocationName;

This is what I have but it telling me "Syntax error(missing operatior) in query expression 'CustomerID=Forms!VenderForm!CustomerID'.

Thanks for your help in advance!

Karima