message box

[macamarr]

Hello,
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? Thanks for Looking!

 

[Fredg]

Hello,
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? Thanks for Looking!

Set the combo box's Limit to List property to yes.
Then use the NotInList event to give the message.

 

[macamarr]

Thank You! Fred

-----Original Message-----


Set the combo box's Limit to List property to yes.
Then use the NotInList event to give the message.
--
Fred
Please reply only to this newsgroup.
I do not reply to personal email.
.