Pop Up Report

M

MBurns

I have created a command button to open a pop up report. How can I make it
only print the record that is selected on the form?
 
A

Al Campagna

MBurns,
Use a key unique value on the open form to filter out all records,
but the one you want. Your form table should have some unique key
field, like a CustID, or EmpID, orSerNo.
Since you provided no object names...

If we had a CustID, then the CustID field in our report query should
have
a criteria of
= Forms!frmYourFormName!CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print one page 3
Report won't show over Pop up form 2
Pop-up form that creates record that links 1:1 to main form 0
Form to Report Filter 1
Print report from form doesn't show current data 4
Print command prints all reports in database? 15
Print a report without displaying print preview 1
Report sorting 1

Top