Printing Subreports

The idea is to have a database with the reports already there on the form for users to print. The information they need is filtered by simply inputting the customer number

and when the reports populate with the information they can click a button and have the subreports print. However i cant 

get them to print filtered with just the selected customer, when we print all customers print off. 

What is the code or macro for the button's Click event?  It will need to filter the report to the current customer by means of the OpenReport method's WhereCondition argument.   Filtering the form does not per se filter the report.

Sorry I don't meant to dodge any questions, I am just so frustrated searching for days and trying so many different codes and none of them are working.  I am sure it's a simple thing but for me apparently it's not. Any help and advice you can give would be greatly appreciated

The reason I have a button to open the report is just to view the print set up and from there we would print it.

The code to open the report is:

Private Sub Command21_Click()

DoCmd.OpenReport "CODE Q & J CREDITS Subreport", acViewPreview

End Sub

The code for my search button on the form is:

Private Sub Command27_Click()

If IsNull(Text25) = False Then

Me.Recordset.FindFirst "[CustNo]=" & Text25

Me!Text25 = Null

If Me.Recordset.NoMatch Then

MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"

Me!Text01 = Null

End If

End If

End Sub

The reason the reports are embedded on the form is so that the user can view the information on the screen first before deciding to print it as they may not need to actually print it.

So you open the report in Print Preview mode or Report view so they can decide whether to actually print it or not.

Most users here do not have a clue how to make queries or filter data so that is why we created this dbase so that all the information pops up once you enter the customer #.

Which is fine. I'm not saying you need to change that at all. I do almost the same thing, except I open the report in Print Preview or Report view once they select the Customer. When the report is opened in Print Preview the ribbon changes where they can select to print, send to PDF etc. If I use Report view I'll have a print button on the report.

I do not have a print button, I just have a simple command button on the report to open it to view. it 

However when we click the button to view the report the information changes and all customers are captured and not the specific customer we searched for.

What button to view the report? Are you saying that after they preview the report on the form you then open the report in Print Preview? Isn't that a redundant step? So what is the code behind THAT button?

My dilemma is with the code, I am not an expert with writing codes etc. and I have tried many different suggestions given from googling this problem but haven't found one that works for me, where

when we click the command button to view the report that that current customers information is there.

I can tell you how to write the code generally, but if you show me the code you are using, I can tell you how to modify it so it does what you want. Both Don and I had given you different ways to do what you want in our initial responses. But if you want an exact answer we need to see the code you are currently using. Reports don't open on their own. Either you select the report from the Nav pane or you have a code behind a control that triggers the report. I'm trying to help you here, but you keep dodging the question I need an answer to to provide that help.

The reason the reports are embedded on the form is so that the user can view the information on the screen first before deciding to print it as they may not need to actually print it.

Most users here do not have a clue how to make queries or filter data so that is why we created this dbase so that all the information pops up once you enter the customer #.

I do not have a print button, I just have a simple command button on the report to open it to view. it 

However when we click the button to view the report the information changes and all customers are captured and not the specific customer we searched for.

My dilemma is with the code, I am not an expert with writing codes etc. and I have tried many different suggestions given from googling this problem but haven't found one that works for me, where

when we click the command button to view the report that that current customers information is there.