HELP With printing!!

[mgillespie21234]

I have a form with a subform on it.




i have a query setup. At the bottom on that query, in the criteria section, i have have set up a filter. The values are entered on the main form from a combo box and then the results are displayed in the subform.


I just need option to print the results that show up in the subform or create a report that can be printed.

[June7]

1. One method is parameterized query, review: http://datapigtechnologies.com/flash...mtoreport.html

2. Another is the WHERE CONDITION of DoCmd.OpenReport, example:
DoCmd.OpenReport "report name", , , "ID=" & Me.comboboxname

Why do you have a main/subform arrangement? Is the subform linked to recordset of the main form? If not, can just be a single form. Use Continuous view to arrange controls like Datasheet and put command button in form header.

[mgillespie21234]

1. One method is parameterized query, review: http://datapigtechnologies.com/flash...mtoreport.html

2. Another is the WHERE CONDITION of DoCmd.OpenReport, example:
DoCmd.OpenReport "report name", , , "ID=" & Me.comboboxname

Why do you have a main/subform arrangement? Is the subform linked to recordset of the main form? If not, can just be a single form. Use Continuous view to arrange controls like Datasheet and put command button in form header.

I have arrangement because it easier for the user i think to just see the results to just see the results on the same page. Maybe im missing the point using a single form with continuous view.

I will try the the second option and let you know how it goes. Thank you!

[mgillespie21234]

1. One method is parameterized query, review: http://datapigtechnologies.com/flash...mtoreport.html

2. Another is the WHERE CONDITION of DoCmd.OpenReport, example:
DoCmd.OpenReport "report name", , , "ID=" & Me.comboboxname

Why do you have a main/subform arrangement? Is the subform linked to recordset of the main form? If not, can just be a single form. Use Continuous view to arrange controls like Datasheet and put command button in form header.

What would i enter for ID=?

[pbaldy]

ID would be your field name. In case the data type isn't numeric:

http://www.baldyweb.com/wherecondition.htm

[mgillespie21234]

ID would be your field name. In case the data type isn't numeric:

http://www.baldyweb.com/wherecondition.htm

DoCmd.OpenReport "pcxloc", , , "OfficalName=#" & Me.lcsrch & "#"

This what i have as my click code and ill show you there error i get:

[mgillespie21234]

the code is behind the command27 button. the location dropdown is Me.lcsrch

SO CLOSE I THINK!!

[rzw0wr]

DoCmd.OpenReport "pcxloc", , , "OfficalName=#" & Me.lcsrch & "#"

I don't understand the WHERE portion of your code.

Why are you using the "#"?

It appears you are tying to call lcsrch a date. Is it?


Dale

[mgillespie21234]

yaeee!! LOL it works. thank you!!

[mgillespie21234]

i changed it from # to '