By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,706 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,706 IT Pros & Developers. It's quick & easy.

From a report back to a form?

P: 34
Hi,
I have a form with a command button that directs you to a report. I need a button on the report, to direct you back to the form. Is this possible? How else can I be directed back to the form without just clicking on the 'close' button on the menu bar?
Jun 11 '07 #1
Share this Question
Share on Google+
5 Replies

NeoPa
Expert Mod 15k+
P: 31,770
Hi,
I have a form with a command button that directs you to a report. I need a button on the report, to direct you back to the form. Is this possible? How else can I be directed back to the form without just clicking on the 'close' button on the menu bar?
What I would do is hide the form when you open the report, then show it just before closing the report.
A more sophisticated system using a special class can be found in Cascading Forms, but for a single situation the former is fine.
Jun 11 '07 #2

P: 34
Tnx NeoPa, great idea. I will try it and let you know how it went.
Jun 12 '07 #3

NeoPa
Expert Mod 15k+
P: 31,770
Please do. As you can see I've had a similar requirement myself, and with the class module, I never have to worry about it any more.
Jun 12 '07 #4

P: 34
Hi NeoPa, sorry for the late reply.
The problem was solved in a very easy way - I changed the report property 'pop-up' to 'yes'. By doing that, the report gets opened in a new window and can be closed without closing the form behind it. I will certainly use your advice when confronted with that kind of problem.
Jun 25 '07 #5

NeoPa
Expert Mod 15k+
P: 31,770
People often say that I come up with extravagantly clever solutions when the plain simple ones are staring me in the face :D
I'm pleased you found what you wanted anyway :)
Jun 25 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.