Help Me..drop downlist to add new data when new data is added

[mk2lee1]

Hi, I have a form in which there is Drop down list linked to table. It source is table called location and the inputs and selection changes another table called presentation, in which field name location exist. What I would like to know is, if I can add the data into location table when there is no same name (as the one i typed) in the selection. So whenever new input is made, it can be available for the selection next time using the drop down list. Anyone with tips?
thank you...

 

[gary40]

hi

i couldnt see any responses to your question so i,ll try to help you out.

why not try and get your drop list data from a table or a query. this means that whenever the source table has a new data item added to it, your drop list becomes updated instantly.

let me know if it works or if ive misunderstood your question.

regards.

gary