I'm using the following
to fill a filed on a form. TransType = numeric, FolderName = String, ClientId = Numeric
This is a continuous form and for every TransType = 2 I get the #error and for the TransTypes 1 I get N/A placed in the field
Any help would be appreciated
Code:
=IIf([TranSType]=2,DCount("[DocId]","DocumentLibrary","[TransType] = 1 And [FolderName] = '" & [FolderFld] & "' AND [ClientId] = & [ClientIdFld] & "),"N/A")
to fill a filed on a form. TransType = numeric, FolderName = String, ClientId = Numeric
This is a continuous form and for every TransType = 2 I get the #error and for the TransTypes 1 I get N/A placed in the field
Any help would be appreciated