Count the number of values in a combo box

A

Alex

I need a msg to appear if the combo box a user clicks on doesn't have any
values listed. I've tried on click, on focus, on enter If Me.Combobox1 = ""
Then Msg ("...."), but nothing is working so I'm thinking I need to code a
different way to count the number of values. Thanks for your help.
Alex
 
A

Al Camp

Alex,
Depending on when you wnat the message to fire off...
This would do it on form Current.
IF cboYourComboName.ListCount = 0 Then
'your message
End if
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
Top