Listbox+Textbox combinition

[ashok]

Hi
I would like place control box which can have the options to enter and select both. Meaning this control has to display distinct values from table during the formload to that control. Incase user doesn't see wish value in the list showing he will enter the newvalue (as of now non-existing value in the table for that column).the control has to accept the manual enter value and insert in to the database. so that the next time form load this new value also come into the list.

could you please advice me which control in the msaccess has this facility. Kindly let me know incase if you need more information about my requirement.
Thanks for looking into.

 

[georgedwilkinson]

Use a combo-box and program the data insert in the "On Not In List" event. There are tons of examples available both here and throughout the internet.

Give us a yell with the correct information (combo-box SQL, etc.) if you need help writing your insert statement.