List values

[simon4amiee]

As I start inoutting data, is there a way access can produce a drop down list from the value I enter eg I enter smith in record 1, jones in record 2, then when I enter record 3 smith and jones appears on a drop down in so on, ie an accumulative list!

 

[maxmangion]

yes that can be done with a combo box on your form. Actually you shouldn't be entering data at table level. Also you may search on this forum for the OnNotInList event so that you can set up how to deal with entries which are not already in the list.