List box: how to know it is empty ?

[halx]

Hello !
I have a list box whose rowsource is defined by a query.
Something like:
Me.lstMyListBox.rowsource = "SELECT ... FROM ... WHERE"

Is there a way to know whether my list box is empty
(ie: whether the query "SELECT ... FROM ... WHERE" is empty ?)
Thanks

Alex

 

[JohnLowell]

You can use listcount for the list box:

If Me.lstMyListBox.Listcount < 1 then
' box is empty

endif

 

[halx]

Thanks !

Alex