Count in VBA

[SiGill]

I have a button on a form. What I want to tell the button to do is count the number of entries in a table, if that count is equal to a certain number then run a macro, if the count is not equal then run a different macro.

How do I use the count function in VBA?

 

[MStef]

Try with DCount function.

 

[DCrake]

Answer = DCount("*","Table")
If Answer > X Then
    Do This
Else
    Do That
End If

 

[SiGill]

Perfect DCOUNT function does the trick

Thanks