Combo Box Msg box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What code do I use in the instance when you type a name into the search combo
box and it doesn't find a record. What event type do I use the code in? I
want it to say, "Record doesn't exist", and then set the focus back to the
search combo box.
 
Kisham,
That doesn't really make sense, since the combo shouldn't be showing
choices for the user to select that aren't legitimate to begin with.
You could use the combo box BeforeUpdate event to determine if a
particular lookup will return a Null, warn the user of that, and cancel the
operation.
But, using that method, you are really not utilizing the power of the
combo box. It should only list legitimate (record/s do exist) choices.
 
Back
Top