Search results

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.

Nope, there is only one join between the table and that is the one I'm having issues with.

This has got me stumped. I am getting the ambiguous outter joins message in a query with only 2 tables. One table contains a list of names. The second table may contain those same names (once or multiple times) or it may not. I want the join property to display all entries from this first table...

I realized the silly error I had with the apostrophes. Those are gone but now I'm getting a Compile Error: Sub or Function not Defined. I think this is coming up because the form I am referencing has spaces in it. I don't want to change the name of the form because it is referenced many times...

I have a form with a button that when pressed brings up a search form. The search form searches a query from which the primary form data is extracted. No errors are being reported with the search, but the search is not functioning properly. I get a message saying the search has filtered the...

When I enter information into two of my five subforms I get the following error: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data...