Command button to Print/View Customer

[teelee]

I have a form named Orders by Customer that has a subform with all the
customer's orders and I want to add a command button on the bottom so that
when an individual customer is showing along with all their information I can
print/view that info for that customer showing. Is there a way I can do this?


Thanks in Advance

 

[Damon Heron]

Design the report for Customer Orders using the report wizard. Then, add
your command button to the form and use the
openreport method to open for the customer that is current. See VB Help for
the openreport method use.

Damon

 

[teelee]

I already have a report with customers orders and added the command button,
but when I click on it I get all the customers showing on the report. I only
need the customer that is showing in the subform.

Thanks

 

[Damon Heron]

Okay, On the command button's properties, you will find the click event.
click on the (...) dots to go to the VB Editor. Add this code,
substituting your field and report names as needed..
Private Sub Command1_Click() ' your button may have a different name

DoCmd.OpenReport "Report1", acViewPreview, , "CustomerID= " & Text0,
acWindowNormal

'(in this case, the field Text0 holds the CustomerID on your form.
"CustomerID" is the name of the field in the table and on your 'report.)
This restricts the report to the customerID of your current form.

End Sub

Damon

 

[teelee]

Ok this is what I have: Private Sub Preview_Report_Click()
DoCmd.OpenReport "Rpt Customer"
acViewPreview , , "CustomerID=" & Text0, acWindowNormal

End Sub
and this is the error message I'm getting: Compile error
Invalid use of Property
Any Suggestions of what I'm doing wrong?

Thanks

DoCmd.OpenReport "Rpt Customer"
acViewPreview , , "CustomerID=" & Text0, acWindowNormal

End Sub

 

[John W. Vinson]

Ok this is what I have: Private Sub Preview_Report_Click()
DoCmd.OpenReport "Rpt Customer"
acViewPreview , , "CustomerID=" & Text0, acWindowNormal

End Sub
and this is the error message I'm getting: Compile error
Invalid use of Property
Any Suggestions of what I'm doing wrong?

Thanks

DoCmd.OpenReport "Rpt Customer"
acViewPreview , , "CustomerID=" & Text0, acWindowNormal

If you have a textbox named Text0 on the form, change Text0 in the above to

Me!Text0

That's a default name for a control, but it's a really bad name from a
usability and documentation standpoint; consider renaming the control and
using the new name in the Me! expression.

 

[Damon Heron]

As I said: "substituting your field and report names as needed"- do you
really have a "text0" textbox with the recordsource set to CustomerID?
If not, change the line to your textbox name. and take John's advice and
include the "me." although it will work without it.
Also, the line beginning "DoCmd." should all be on one line, hopefully that
is what you did, sometimes its hard to tell with News posts.

Damon