Return without GoSub

[Karin]

Hi, I have a bunch of command buttons on a switchboard, most of which run
either queries or reports. I have been slowly working on getting ready to
split the database, but have not yet done so. I did do a few things as
suggested in this site
http://www.accessmvp.com/TWickerath/articles/multiuser.htm. Whatever I did
has resulted in the Return withoutGoSub for every button on the form. I can
run the individual queries and reports without any problem, just can't run
them from the button. Create new button, no problem, but it won't run - same
error. Any suggestions for what I screwed up? TIA! Karin

 

[Marshall Barton]

Hi, I have a bunch of command buttons on a switchboard, most of which run
either queries or reports. I have been slowly working on getting ready to
split the database, but have not yet done so. I did do a few things as
suggested in this site
http://www.accessmvp.com/TWickerath/articles/multiuser.htm. Whatever I did
has resulted in the Return withoutGoSub for every button on the form. I can
run the individual queries and reports without any problem, just can't run
them from the button. Create new button, no problem, but it won't run - same
error. Any suggestions for what I screwed up? TIA! Karin

It's difficult to analyze your button's code unless you post
a Copy/Paste of one of the procedures with the problem.

Without that critical information, all I can do is guess
that you have a Return statement in the Click event
procedure.

 

[Tom Wickerath]

Hi Karen,

I can't think of anything you may have done based on my article that has
resulted in this error.....

Try opening any code module (use <ALT><F11>). Then click on:

Debug | Compile {ProjectName}

where {ProjectName} is the name of your VBA project. Does your project
compile without any errors?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________