Checking if Combo Box contains data

[Luddite Lad]

What is the syntax to check if a combo box populated by a query contains data?

 

[pono1]

First thought...

Pseudo-code:

If DCount(combobox's SQL Query Equivalent) > 0 Then
   ComboBox Has Data
End If

Regards,
Tim

 

[WayneRyan]

You can reference --> Me.YourCombo.ListCount

Wayne

 

[pono1]

You can reference --> Me.YourCombo.ListCount

Wayne

Much better, Wayne...

Regards,
Tim

 

[Luddite Lad]

Thanks guys works a treat