http://odyssey.apana.org.au/~abrowne/ser-28.html
I'm trying to use the code from the above web site to filter a subform. I keep getting compile/syntax errror on the portion at the bottom:
MsgBox Err.Number & ": " & Err.Description, vbInformation, & _
Me.Module.Name & ".cboShowJob_AfterUpdate"

It's all pasted and copied directly from the text except for the name of the combo box (cboShowJob). Can anybody tell what's wrong?

I took the last Ampersand out (to wrap the line to the next line) and it eliminated the error message:

MsgBox Err.Number & ": " & Err.Description, vbInformation, _
Me.Module.Name & ".cboShowJob_AfterUpdate"


The message is clearer if you choose Compile All modules or compile all loaded modules from the debug menu. The message from this one was: "...Expected Expression." My past experiences told me to try it without the ampersand.

Thanks a lot, that fixed it!