One Command button for different reports

  • Thread starter Thread starter Francis Cunningham, Jr.
  • Start date Start date
F

Francis Cunningham, Jr.

I have five different reports called ‘Cooling, Electric, Gas, Heat Pump and
Oil’
I would like to create a one command button on a form called ‘Contract’,
that based on two fields on this form, called ‘ContractNumber’ and
‘ContractType’ will generate the specific report. The ContractNumber is
unique (primary key, required and no duplicates allowed) to the form
‘Contract’. So based on the ContractNumber and the ContractType on the form I
would like the result to be the correct report for the customer.
How the forms are laid out are:
Form - Contacts, which includes name, address etc, phone number (which is
the ContractNumber)
Form – Contract, which includes the ‘ContractNumber and the ContractType’
(Cooling, Electric, Gas, Heat Pump or Oil).
Can someone help?
Frank
 
You asked about "reports" but described "forms". In Access, forms display
data on-screen, reports are for displaying data on paper.

So, what does form layout have to do with your reports?

What about ContractNumber and ContractType tells you which report to run?

Do you use queries to "fill" your forms? Do you base your reports on
queries?

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
The result of clicking the command button is a report.
The form layout is just to give a visual of what I am doing.
By using the ContractNumber and the ContractType it narrows down the search
to the one specific record.
Queries do not complete the forms.
The reports are based on queries. I was not sure which community to post
this question. Hope this helps.
Frank
 
Back
Top