I need help with Access?

Question

I've got lookup list yeh another word Dropdownlist. I want the user to only select the data from the dropdpwnlist, they should not be able to enter any data themself if a dropdown list is avialable...

i hope this makes sense please help me !

Answer 1

Define a look up table LU_myList using a single text field as the primay key. Then load your list items into teh table.

Define your data table T_mydata, from within the table designer you can define a lookup by clicking on the lookup tab. On the user control option select drop down list and then select the look up table LU_myList.