Blank Form

[Guest]

Hello. I have a form with a combo box in it which has a list of part
numbers. When the user enters a part number from the list and hits the
"Execute" button it takes them to another form which has detailed info about
that particular part number. HOWEVER, if the user enters a bogus part
number, it takes them to a completely blank form. I would like to know how
to make it so that instead of going to the form it simply says "Part Number
Does Not Exist." Any help on this is greatly appreciated. Thanks

 

[Guest]

You can set the LimitToList Property of the combo to Yes, that way the user
won't be able to enter parts that doesn't exist in the list

 

[Fred Boer]

Dear Mr. Smiley:

Comboboxes have a property called "LimitToList". If you set this property to
"Yes", entering anything that isn't a choice on the list will generate an
error message.

HTH
Fred Boer

 

[Guest]

Fred and ofer, thank you both very much. This worked.