Lookup Box

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

Guest

I have a Lookup Box on a Form that looks up specific numbers (No Duplicates
allowed) and an After Update Event Procedure to alert the user if they try to
duplicate the number.
This number can be deleted as required. The problem is if someone
accidentally deletes the number and tries to re-enter the number straight
away, the Message appears that duplicates are not allowed. If the user
enters this number again it is then accepted. The number stays in the Lookup
list until the user moves to another record or Exits. Is there a way the
number can be removed from the Look Up box as soon as the Enter key is
pressed? There is an after update event procedure in the form design
properties to requery the Combo Box, but this makes no difference.

Thanks for any help
 
What control are you using for your "Lookup Box" and why not use the
BeforeUpdate event and Cancel = True when there is a duplicate?
 
Back
Top