DCount syntax

[DebSabre]

I get an error when I try to run this. Can anyone let me know what the proper syntax is for this? Thanking you in advance.

Dim strWhere as String
strWhere = "[DrNumber] = '" & [cboField] & "' And [DRNUMBER] is not Null "
nCount = DCount("[DRNUMBER", "FIREARMS", strWhere)

 

[DebSabre]

I just figured out what was wrong!!! Thanks anyway.

nCount = DCount("[DRNUMBER]", "FIREARMS", strWhere)

didn't have the closing ]