Problem with NotInList

[Kevin McAbee]

Hello All,

I was wondering if you could answer a quick question for me.

I have a combo box that is using a query as the recordsource. I am having
the users type in the name of the organization in the combo box and using
the id of the organization as the hidden (width of 0") bound column.

I have written code for the notinlist event that will trigger a dialog form
so the user can enter data about new organizations. However, the name they
enter in the dialog form may end being slightly different (more complete I
should say), than the name they were typing in the combo box. If the name
is different, then when the dialog form closes, the combo box will kick out
a "item not found in list" error. If I set the combo box's value to the
integer id of the newly created organization, it will still kick out the
answer and not perform an autoexpand on the organization name.

Now here's the kicker - if I have the bound id column visible and as the
column to match when typing in the combo box, all works well. However, it
does not work when that bound column is hidden.

Any suggestions on how I can overcome this?

Thanks,

Kevin

 

[Rick B]

Please do not post separate messages to multiple newsgroups for the same
issue. It means that more than one person will spend their time answering
your question only to find it already answered in another group.