Print one page sub report from subform

[GooGoocluster]

I have been getting a lot of help from everyone here so I appreciate everyone’s help. I am so sorry for all the questions.

Here is my setup I have a form that looks like this sub forms under the main.

Main-Client
Sub-Project
Sub-Job ----> with button to print report

Report looks like this:

Main-Client
Sub-Project
Sub-Job

Is there a way to print the one page of the report that corresponds with Job = Job?

Again thanks for everyone’s help. My project is really coming together. Just wish I had VB so I can turn this into a program.

 

[GooGoocluster]

I think this is possible.. let me know if I can explain more. Also does anyone know of a good programing book for Access.

 

[GooGoocluster]

Is there a way to at least have it open to the current page of the report? Is this the right forum for this?

 

[GooGoocluster]

This is what I have in the main report that works

code:

Me.Filter = "Client = "" & Forms!ClientList!ClientName & """

Then when I put this in the subreport that is refering to the subform

Me.Filter = "Project = "" & Forms!ProjectSub!Project & """


this gives me an error saying "the setting you entered is not valid for this property.

When I look at the property it shows just the code rather then the value ("Project = "" & Forms!ProjectSub!Project & """).

As far as I can tell this should be right

 

[PHV]

And this ?
= "Project=Forms!ClientList!ProjectSub.Form!Project"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Walkinman17]

Quotation marks (single and double) are tricky.

You have
Me.Filter = "Project = "" & Forms!ProjectSub!Project & """


Try
Me.Filter = "Project = " & "'" & Forms!ProjectSub!Project & "'"

w17