DCount Syntax Help

[systematic]

Hi all,

I have scoured the net and these forums....although there is plenty of information on DCount I can't seem to find the answer to my question so thought it was time for a post.

I am trying to get the following to work -

PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = strPS")

or alternatively, reference the control directly (instead of strPS, use Me.cboConsultant)

I have tried that many different combinations of " and ' still with no joy - the best I can do is return a value of zero.

Could someone please help me out with the syntax? btw...strPS is a text string - in case this is relevant.

Thanks

Robert

 

[systematic]

Always the way....as soon as I post I figure it out

PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = '" & strPS & "'")