Combo Box NotInList capture data

T

Tom Ross

Hi

I have a combo box (ItemType) reading values from a table.

It is set to limit to list and the not in list event has a message box
instructing the user to select 'Other' in the combo box and then put his new
item in the 'OtherDetails' textbox. If the user selects OK I try to do that
for him with the following code.


ItemTemp = Me.ItemType
Me.ItemType = "Other"
Me.OtherDetails = ItemTemp

However ItemTemp is set to the value that was in the combo box BEFORE the
user tried to enter a new value that is not in the list.
I don't want that value. I want the value that the user typed so I can
store it in the proper place.

Any Ideas?

Tom
 
Top