open report from a button in a form

R

Rae

I have a database with lots of reports and I want to be able to access them
quickly rather than scrolling down a list. I created a form with command
buttons to open the reports using the button wizard, but the form appears as
an unrelated object, and when you reopen the form, it doesn't do anything.
Help!
 
K

Keith Wilby

Rae said:
I have a database with lots of reports and I want to be able to access them
quickly rather than scrolling down a list. I created a form with command
buttons to open the reports using the button wizard, but the form appears
as
an unrelated object, and when you reopen the form, it doesn't do anything.
Help!

What do you mean by "unrelated object"? The way I do it is to have a form
with a list box bound to a table which contains each report's details, that
way the user can choose the report from a list and the command button opens
it.

Keith.
www.keithwilby.co.uk
 
R

Rae

When I create a button, it allows me to choose the function of opening a
report and gives me a list of all my reports to choose from. When the wizard
closes and I try clicking on the button, it doesn't do anything. When I save
the form, it appears in the Navigation panel under a tab called 'unrelated
objects'.

I was going to create a form with 12 buttons, each of which leads to another
form with 6 buttons each and these buttons should open the relevant report.

(This is my first time to do anything like this and I have a very basic
access knowledge!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top