Access 2007
I want to create a button to view a specific report. The report, of course, is the information from one record in a table. The button I have created opens up the report but it shows every record..for example I have 22 records thus far, so when I click on my "view Report" button I get 22 pages to view. I just want one, specific, report to show up.
Which brings me to my second issue..I want to have a button that when clicked a window pops up asking what report I want to view, I type in the report number, then I can click print to print that specific report.
Would I have make a query with a "Like" command in order to do any of the above?
I want to create a button to view a specific report. The report, of course, is the information from one record in a table. The button I have created opens up the report but it shows every record..for example I have 22 records thus far, so when I click on my "view Report" button I get 22 pages to view. I just want one, specific, report to show up.
Which brings me to my second issue..I want to have a button that when clicked a window pops up asking what report I want to view, I type in the report number, then I can click print to print that specific report.
Would I have make a query with a "Like" command in order to do any of the above?