Combo box used to find record in form 2

[Cordeiro82]

Hello,

I am using a combo box to lookup records in a form based on Vendor ID.

If the user enters a vendor ID that is not in the table the form defaults to the first record in the table.

How can I have the form display a pop-up notifying the user that the Vendor ID is not in the system and then default to a new record instead of the first record in the table.

Thanks.

 

[randy700]

Use the NotInList event.

Randy

 

[PHV]

And set the LimitToList property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cordeiro82]

Thanks guys