Help with a DCount

[gheyman]

I want to look in one table (tblRFPManager) and count how many times a value from a Textbox on a form appears.

I want to search a table named tblRFPManager in a field named PID_Number. I want to know how many times the value on my form frmPIDGenerator in TextBox Text97 appears in the table.

Is it

DCount([PID_ID],[tblRFPManager],[PID_Number]=Text97)

Im away from my db so I cannot try it. Do I use the brackets?

Or would it be
DCount(PID_ID,tblRFPManager,PID_Number=Text97)

Or neither?

 

[stumac]

Neither - the expression and the domain are string arguments therefore need to be treated as strings:

Dcount("*","TblRFPManager","[PID_Number] = " & Text97)