I have a combobox on a form where:
ControlSource is m.comments
RowSourceType is 6-Fields
RowSource is Table_A.Code
I want the user to either select from the table, or enter his own text.
The problem occurs when the user enters his own text. I don't want to add that text to be added to my table; all I want is to have my ControlSource populated with whatever the user entered, and I want that text to remain visible in the combobox when the user moves to another control. (Silly me, I thought that's the way it would work by default!)
Thanks in advance
Jim Nelson
Jim Nelson
Newbury Park, CA