drunkcrusher78
Registered User.
- Local time
- Today, 12:57
- Joined
- Mar 16, 2004
- Messages
- 13
I have 7 different reports that pull information from a single query. The names are as follows:
RptChecklist
RptRightsform
RptCitation
RptAdminhearing
RptArrestaffd
RptPropertyRecord
RptMarshalsheet
In the main query, I have a primary ID field of Case Number, which is unique to each record in the query. The simple method that I would like to create, is for me to be able to click on a command button, it ask me to enter the Case Number, and it print ONLY the record from the query with that case number for that report.
Now, ultimately what I would like to do, is be able to click on a single command button, and it print each of the reports above, sequentually, by entering the Case Number and printing only that record. Some records are 2 pages, some are 4 pages long.
Please be simple in your response, Im still learning. I have played with the several of the Macro Commands, etc. but can't get it to filter only the record that I need.
Thanks in advance.
Oren Haydel
RptChecklist
RptRightsform
RptCitation
RptAdminhearing
RptArrestaffd
RptPropertyRecord
RptMarshalsheet
In the main query, I have a primary ID field of Case Number, which is unique to each record in the query. The simple method that I would like to create, is for me to be able to click on a command button, it ask me to enter the Case Number, and it print ONLY the record from the query with that case number for that report.
Now, ultimately what I would like to do, is be able to click on a single command button, and it print each of the reports above, sequentually, by entering the Case Number and printing only that record. Some records are 2 pages, some are 4 pages long.
Please be simple in your response, Im still learning. I have played with the several of the Macro Commands, etc. but can't get it to filter only the record that I need.
Thanks in advance.
Oren Haydel