Updating table using combo box

[eHigh]

Users would like to select from a combo box and if their selection is not there they would like to enter the data into the combo box and update the undelying record source for future selections.

Is there a simple way to do this?

Thanks.

 

[PHV]

Take a look at the NotInList event.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Zion7]

Yes as PHV said, or

from the properties dialog,
select LimitToList = No
On the afterUpdate event of cbobox put Me.Refresh,
the update should be immediate.

Hope this helps, good luck!

 

[eHigh]

Thanks!

You guys and this website are a great resource!