[AccessD] Data Type Mismatch in criteria expression

[Bob Heygood]

If you have a moment, can you look at this snippet ?


Don't judge me, I inherited the table and field names. And I figured it was
too much to change all the rookie naming conventions....

I just can't see the problem.

"agentid" is a field name in the table "agent". It is a primary key and a
STRING data type.
intAgentCount is a integer type vba variable.
strAgentID is a string type vba variable.

    intAgentCount = DCount("agentid", "agent", "[agentid] = " & strAgentID)

My objective is to determine if a record is already in the table for a given
agentid, and if not, to insert one.

TIA

Bob Heygood