I have some text fields in a subform that need to show a few counts - it works great in Access 2007, but crashes Access 2003...here is what I have in the control source for one of the text boxes:
=DCount("[ID]","Note","[ContactID] = Forms![Customer Edit]![Contact List subform].Form![ContactID]")
The problem is with Forms![Customer Edit]![Contact List subform].Form![ContactID], because if I change it to an integer the count processes as it should. Can anyone tell me what should be there so this function will operate in all versions of Access?