Count the number of values in a combo box

[Guest]

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

 

[Guest]

If Me.MyCombo.Listcount = 0 Then
MsgBox "Nothing found"
End If

 

[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

 

[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

 

[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

 

[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