Hello,
I have a form (frmClients) on which i'm trying to update a field using a button on click event, with the vba code:
Me.[Number] = Nz(DMax("[Number]", "QryClientsExt", "[LocationID] = " & [VarTemp]![Location] & " And [WorkplaceID] = " & Forms("frmClients").Workplace.Column(1)), 0) + 1...