error on Do.Cmd of chosing reports from list box 1

[MICKI0220]

thread702-1013991

referencing the above thread, I was trying to accomplish this by doing it the way FancyPrairie said.....I come up with an error on the Do.Cmd of the after update statement, can you clarify?

 

[randy700]

You don't say what error you are getting, but...
Try changing Do.Cmd to DoCmd.


Randy

 

[MICKI0220]

oops...I changed it to the right syntax and now I get the error message that.....

"The expression After Update you entered as the event property setting produced the following error: Invalid outside procedure."
*The expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

 

[dhookom]

Is your code in the code window or in a property? You should be in a window with "Microsoft Visual Basic..." in the title.

Duane
Hook'D on Access
MS Access MVP

 

[MICKI0220]

I figured it out.....under the Option Explicit there was an "end sub"

Thanks for the help