combobox question

[macamarr]

When using a combobox, instead of scrolling through to find the account number I am searching for, I type in the account number. The problem I am running into is if there is no match the information on the rest of the form remains the same. What I need to have happen is; if there is no match have a message box appear stating "no match". Is this possible?

 

[Russell Hauf]

In the properties of the combo box, change the Limit To List property to Yes. This will pop up a message telling the user that they must pick from the list.

HTH,

Russell