Command button based on a query.

  • Thread starter Thread starter Emma
  • Start date Start date
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.
 
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?
 
Back
Top