F
Francis Cunningham, Jr.
How do I call up a specific report based on 2 fields on a form?
To explain myself. I already have the form made, and on the form are the
fields CustomerID and ContractID. I would like the create a command button
on this form and when clicked it would open the report based on the
CustomerID and ContractID there are 4 or 5 report possibilities. The
CustomerID and ContractID are fields on two different tables.
I have 5 reports, each design is different. I would like the form field
‘ContractID’ determine which report opens to print or preview.
For example:
ContractID=Gas then print Report ‘Gas’
ContractID=Electric then print Report ‘Electric
ContractID=Heat then print Report ‘Heat’ and so on.
If anyone can help me with this I am greatly appreciative.
Frank
To explain myself. I already have the form made, and on the form are the
fields CustomerID and ContractID. I would like the create a command button
on this form and when clicked it would open the report based on the
CustomerID and ContractID there are 4 or 5 report possibilities. The
CustomerID and ContractID are fields on two different tables.
I have 5 reports, each design is different. I would like the form field
‘ContractID’ determine which report opens to print or preview.
For example:
ContractID=Gas then print Report ‘Gas’
ContractID=Electric then print Report ‘Electric
ContractID=Heat then print Report ‘Heat’ and so on.
If anyone can help me with this I am greatly appreciative.
Frank