Display Message When Nothing Is Selected From The Listbox.

[Aleni]

Hi!

I have a form which contains listbox and a button.
When a user clicks on the button i want to open another form only if something is selected from listbox.
If user clicks on the button without selecting anything from the list box i want to display a msg saying the user to select something from the list box.

First part i could do but I have problem with the second part.

What is the way to solve it?

 

[pr2-eugin]

Try this..

If (Me.[COLOR=Blue]fieldList[/COLOR].ItemsSelected.Count = 0) Then
    Call MsgBox("Please SELECT atleast one field from the List.", vbInformation, "Missing Information")
    Exit Sub
End If

Change the blue bits..

 

[Aleni]

Thank you pr2-eugin.
Its working fine now.