Button on form to print report for current record

A

Anita

I want to put a button in my input form so it can print a report looking at
only the current record I am in using2007.

See names below:

Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form

Can anyone help? thanks so much
 
D

Douglas J. Steele

Try:

DoCmd.OpenReport "Customer Complaint Form", acViewPreview, , _
"[CC Number] = " & Forms![CC Form Entry]![CC Number]
 
A

Anita

Brilliant! thanks so much - worked 1st time

Douglas J. Steele said:
Try:

DoCmd.OpenReport "Customer Complaint Form", acViewPreview, , _
"[CC Number] = " & Forms![CC Form Entry]![CC Number]

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Anita said:
I want to put a button in my input form so it can print a report looking at
only the current record I am in using2007.

See names below:

Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form

Can anyone help? thanks so much


.
 
D

De Jager

Anita said:
Brilliant! thanks so much - worked 1st time

Douglas J. Steele said:
Try:

DoCmd.OpenReport "Customer Complaint Form", acViewPreview, , _
"[CC Number] = " & Forms![CC Form Entry]![CC Number]

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Anita said:
I want to put a button in my input form so it can print a report looking
at
only the current record I am in using2007.

See names below:

Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form

Can anyone help? thanks so much


.
 
A

Augusto Senesi

Anita said:
I want to put a button in my input form so it can print a report looking
at
only the current record I am in using2007.

See names below:

Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form

Can anyone help? thanks so much
 

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

Top