[MS_AccessPros] On close event of report can i have more than one option to open a specific form in access 2007

 

Hi John,

A new situation has arrived to me.

On my frm "MainMenu" i have few command buttons to open certain forms/Reports.

Suppose through button "Reports" we have opened some report, on that reports On Close Event the code is:

Private Sub Report_Close()

    DoCmd.Close acForm, "Dialog Invoice And Packing List"

    DoCmd.OpenForm "Export Documents" <======

    DoCmd.Restore

End Sub

Here at this point can i have any choice that user may be asked whether he wants to open again "Export Documents" OR go to "MainMenu".

This is because my boss has asked me to  put something on Main Menu for "Frequent Inputs/Reports" for this i have put some Labels for 

Frequent Inputs/Frequent Reports, and from there On Click event open the required Form/Report, the desired forms/reports by him.

For the Forms i have put two buttons:

Return To Previous Menu

Return To Main Menu

This fulfills my requirement for forms, but need help for Reports.

Regards,

Khalid

__._,_.___

---

Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___