Second request combobox notinlist behavior

[ktdid]

Hi - In the database I designed for a client, when they enter a value in the
combobox on the form that is not in the list, instead of the usual dialog box
popping up on top of the form where they can see it, it seems to hang behind
the scenes. They hear the beep but can't get at the box and can't continue
on the form. I do have a conditional macro on that combo box that pops up a
dialog box suggesting a different id when they enter certain ones. When I
removed that, though, I still had the problem. I don't seem to have this
problem on my laptop. Please, please help. Access 2000 db running in 2003.

 

[Tom van Stiphout]

On Wed, 8 Jul 2009 14:40:01 -0700, ktdid

Much more common than your conditional macro is to write code in the
dropdown_NoInList event. Try that, and post your code if you're still
having problems.

-Tom.
Microsoft Access MVP

 

[ktdid]

Hi Tom - Thanks but the notinlist event is not part of my macro. It is what
happens automatically when Limit to List is set to Yes in the properties.
Also why would this be a problem on a client workstation but not on my
laptop? Only difference I see is I have SP2, they have SP1. Help?