dropdown list

[hendrikbez]

I an new to Acess, and have make this database, I have 3 tables that I trying to use as dropdown list, did the dropdown list but I do not know how to use it, it does not work and I cannot add new records.

Here is my file.

 

[llkhoutx]

This sounds like a programming class question. Use a query as the data source for the combo box (dropdown) list, with only the fields you want. New records (daa not in th list) can be added to the list via the "Not In List" event. For a neophyte, that ADO or DAO coding would be difficult without a better understanding of combo boxes. Good luck.