See function Audit(..) below.
I have just amended this function to accept a second argument (Auditcat).
I then changed my VBA that calls the function to the following;
I get an immediate compile error "Expected :="
I have never passed 2 arguments before - it seems to be the second argument that is causing the problem?? Is the syntax in Audit("a","b") wrong ?
If this is not clear I can create a database with an example and attach it.
Function Audit(ByRef PrimaryKey, ByRef Auditcat)
On Error GoTo Audit_err