Recent content by sokolln

works wonderfully. thank you

Ugh. It couldn't be that easy. Do you see anything silly I'm overlooking here? Private Sub cmdPrntFrm_Click() Dim stDocName As String stDocName = "Auto-Generate UP Form" If Forms![Master Form by Ult Parent].FilterOn And Len(Forms![Master Form by Ult Parent].Filter & "") > 0 Then...

A curve ball yes. The form the data is displayed in is quite data heavy - one record takes up multiple pages. The idea with the new form is just the essential information so matches can basically be shown in a list format.

Brilliant! It works! Thank you! Would having this command open a form that displayed all the info together be as simple as changing the report references to form references?

Yes I caught that one myself. The code is: Dim stDocName As String stDocName = "Organizational Profile" If Forms![Master Form by Ult Parent].FilterOn And Len(Forms![Master Form by Ult Parent].Filter & "") > 0 Then MsgBox GCriteria DoCmd.OpenReport stDocName, acViewPreview...

The search works with that but the report function is still pulling up all records

Oh yes, I've learned the hard way about those spaces. Never again. Anyways, the result of the modified code is the search does not work....

I may not be doing this right. The code I'm working with is: Private Sub cmdPrntFltr_Click() Dim stDocName As String stDocName = "Organizational Profile" If Me.FilterOn And Len(Me.Filter & "") > 0 Then MsgBox GCriteria DoCmd.OpenReport stDocName, acViewPreview, WhereCondition:=GCriteria Else...

Thanks. Ok that's what I thought. I had tried that and a report for all records was displayed. Any other thoughts?

My appologies, but I am lost. How do I use GCriteria when filtering the report?

I have seen the other posts in the same vein as this question but I've been unable to solve my problem. I have a search function and when the search is executed I would like to view reports based solely on the search results. The code I am using is as follows: Dim stDocName As String stDocName...

Check this out... http://www.access-programmers.co.uk/forums/showthread.php?t=79670

Fixed! Thank you guys for your help.

I've attached a snippet of the database with the problem. I am trying to run the sole query.

I may not understand what you are saying. I think there is just one field in the join. The query is joining the field "Ultimate Parent" from one table to the field "Ultimate Parent" in the second table.