Hi Everyone. I have a form that displays all open work orders. I am trying to get a calculated filed to count the number of items on that work order using the dcount. The code looks right but it keeps displaying "#ERROR". I'm sure the mistake is in the parameters I am laying in but I'm not sure where.
I am attempting to put this code into the default value property for the field.
=DCount("[ID]","TBLAcft_Desc","[N_Number] = '" & [Forms]![frm_WO_Cont]![txt_tail] & "'")
I am attempting to put this code into the default value property for the field.
=DCount("[ID]","TBLAcft_Desc","[N_Number] = '" & [Forms]![frm_WO_Cont]![txt_tail] & "'")