Command button based on a query.

E

Emma

I have made a small database that has a form on it that shows all of the
member details. I have also created 6 different reports that depend on what
number profile group the member is in. All of the reports are built with a
query which uses the member number in the form and links to a particular
table for their profile group.
I want to create a command button on my Form that on click opens 1 of the 6
reports that links the producer number on the form to open the relevant
report.

I am sure that i need to build a querry to do this but i can't think of what
to do. Please can somebody help me.
 
E

Emma

Hi i see what you mean by that but I have got over a thousand members and
they all link to one of the 6 reports. If i use this function will it link to
the report that corresponds with their member number on the form?
 

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

Similar Threads

Counting multiple memberships 1
Open Report 1
Query on a subform 1
Duplicate report pages with select query 1
Parameter Query Won't Run 0
Run select query from VBA code where criteria comes from a multi select ListBox 2
Query with Multiple Criteria 4
Combo Box, Query and Report 5

Top