syntax error

vickiwells

Registered User.
Local time
Today, 21:03
Joined
Jun 30, 2000
Messages
61
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!
 

Users who are viewing this thread

Back
Top Bottom