How to tell Access to check if Listbox is populated and then carry out

[KennyUK]

Hello,

I have a problem and I wondered if the experts of this group could help me out.

I have a list box on a form that to simple, I will call "List1" and the form is called "frm1".

I would like to tell Access to check if the list box has any data in it and if so then perform Task A
but if not perform Task B.

Can anyone tell me the correct method or syntax for doing this as I can not seem to get it right.

Thank you in advance,

Kimi.

 

[1127]

If You want to check the list from another place that the Class Module of frm1 then:

If Forms("frm1&quot.Controls("List1&quot.ListCount > 0 Then
<TASK A>
Else
<TASK B>
End If
or
If Forms(&quot;frm1&quot.List1.ListCount > 0 Then
<TASK A>
Else
<TASK B>
End If

If You check it from whitin the frm1's Class Module:
If Me.List1.ListCount > 0 Then
....
Else
....
End If

Beware, in the first situation You have to have the frm1 open.

Tibi