Button on form to print report for current record

  • Thread starter Thread starter Anita
  • Start date Start date
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
 
Try:

DoCmd.OpenReport "Customer Complaint Form", acViewPreview, , _
"[CC Number] = " & Forms![CC Form Entry]![CC Number]
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
 
Back
Top