cbo: IS in list

richard luft

Registered User.
Local time
Today, 11:35
Joined
Jun 4, 2004
Messages
63
Hi;
Hoping that someone can suggest a solution for the following:
I have a form “frmAdd_Client”, on which, in the form header there is an initial (field(0)) cbo “cboSelect_Client”. Into this control is entered Surname,Prename;Date of birth.
If the new data is ‘not in list’, then the detail section of the form is enabled for data entry.
When the data entered into the cbo IS in list, I would like a msgbox to appear such as “Client is already in system”.
Is there any way to code such an event of ‘is in list’? If so , in which event of the cbo should the coding appear?
TIA, Richard
 
Use the text boxes Before_Update event and a Dlookup to check for duplicates
 

Users who are viewing this thread

Back
Top Bottom