Criteria in DCount

[padlocked17]

Good EVening -

I need to set the criteria in a DCount to make a column = "CurrentFEVersion" in my options table but I'm not sure how to reference it.

Does anyone have any suggestions?

Thanks!

strFEMaster = DLookup("OptionValueTxt", "tblOptions", [OptionType] = "CurrentFEVersion")

 

[Calvin]

Try:

'This assumes your variable CurrentFEVersion  is a String
strFEMaster = DLookup("OptionValueTxt", "tblOptions", "[OptionType] ='" & CurrentFEVersion &"'")

'This assumes your variable is numeric of some kind (integer or long)
strFEMaster = DLookup("OptionValueTxt", "tblOptions", "[OptionType] =" & CurrentFEVersion )

 

[padlocked17]

Turned out I needed to use:

DLookup("OptionValueTxt", "tblOptions", "OptionType = 'CurrentFEVersion'")