search Report, Text

[mike02]

Hey, In my Database i have a list of returns. it gives a repeat of the name for each row. Depending on the number of Returns, depends on the number of names repeated. I have the list generated giving me a table. Now I also have a Graph in this report. I want to specifically search the report through a Form. Now I have been able to search other reports based on the Specific Id while only showing the Name, is there away to Search soly on the Name its self. I know its not as unique as an id etc. Thanks

[June7]

Yes, you could search on any field that is included in the RecordSource. I just don't know enough about your structure to give specifics.

[mike02]

I have a report query which links 5 tables into one report, I need to filter through a combo box the name on a form, each table has every name in the same inputted order etc.

[June7]

That doesn't really tell me what your issue is. Why can't you do the search? What do you want to happen when the name is selected in combobox? What have you tried? Do you get error message, wrong results, nothing? Show code or provide the project for analysis - follow instructions at bottom of my post.

Why is the name in all tables? This sounds like duplication of data.

[mike02]

This is what i have been doing. In the criteria section of the report query i have been putting this: Like [Forms]![ReportCenter].[Form]![MyFundName] & "*"
I have it set up that the report opens in a Report center form, ie a navigation form. Because of this it is a subform essentially. so that is why i have .[Form] after report center. I have named the combo box MyFundName.
It is not duplicate data because each table contains a unique fields. I have a table for managers, Strategy, Decision, Performance, Risk. The Name in each table helps keep data together. I thought about if ithere is a better way andwith my brief experiance i couldnt think of one. If there is a better way please let me know. Now each ID is the same for each fund. The ID is the primary key in the tables. When the name is selected i have it set to requary after update. I want the name to be selected and filter through the report and bring only that names information, I have it group by the Name. I have each Name starting on a new page (Group and sort was handy for this). Now the way im trying to filter worked for me within forms etc through navigation forms. the error is that it doesnt recognize it. I have had it work for forms, and my research online says it will work with reports as well. Also I have made sure spelling and everything is correct.

[June7]

I have never used a report on a form. So did quick test of this. An unbound combobox provides criteria. Code in AfterUpdate event of combobox filters the report. Works great! I can actually use this. Example:
Me.Child0.Report.Filter = "UmpID='" & Me.Combo2 & "'"
Me.Child0.Report.FilterOn = True

What is your code? I did not use query input parameter (don't like them). Your code probably should be a Requery of the report.

Using names as unique identifiers has risk. What if you have two John Smith? Might be better to save an ID instead of name into each table. What are these names for - the managers?

[mike02]

Attachment 8342The name is for the comapny. the reason i want to use the company name as a filter is because i have a table on the form and the company would be selected multiple times :S ive been struggling with this for a while now, keep moving on to something else and hopin i eventually figure it out. Thanks for the help, ill give ait a shot through code instead of query paraameters. Attached is the jist of what im doing, i apologizze for not being able to disclose anymroe information

[June7]

Since you did not provide data, can't test.

You do have a macro for the Requery but don't specify the subreport container control as the target of the requery.

I don't use macros, only VBA.

[mike02]

I appreciate the help, the reason it doesnt specify the report, is I believe that once the report comes up in the form, It is based on an empty combo box because it has already been told, so when I requery it will automatically tell the report this is the contents i want you to search on.
Thanks,

[June7]

So is that working?

[mike02]

Ive been away, back at it tmw. once i figure it out i will mark this thread solved!

[mike02]

I cant even get it to recognize it. the path is not recognizable:S yet all names are correct... Like Forms!ReportCenter.Form!SearchFund & "*"
Ive been working just in the query to get it to work. so im very confused on what is wrong. all my combo box filters are based with parameters and all work. except for the one going into the report.

[mike02]

Here is a copy. I want to be able to search aaa in a combo box or bbb for example. I have a id. but it still isnt working. i removed my Parameters and here is an example of the database attached.Attachment 8384

[June7]

The filter doesn't work because the report RecordSource does not have filter parameter and the Requery macro does not specify what is to be requeried. When I converted the macro to VBA, the result was:
Private Sub SelectFund_AfterUpdate()
DoCmd.Requery ""
End Sub

I never used navigation form and I find it confusing. When I tried to modify the report RecordSource with a WHERE clause that references the combobox as input parameter, all the controls show invalid ControlSource error. Weird.

So gave up and went with code to set Filter property. It works.

Private Sub SelectFund_AfterUpdate()
Me.NavigationSubform.Report.FilterOn = False
Me.NavigationSubform.Report.Filter = "ID=" & Me.SelectFund
Me.NavigationSubform.Report.FilterOn = True
End Sub

There might be macro equivalent to the VBA procedure but I don't use macros.

[mike02]

Hey THanks so much for taking a look for me, now im new to code and all. Im more familiar with macros, but that hasnt worked for me yet so im going to give code a shot! Works Like a charm! thanks so much! With regards to having charts in a report does the code change at all? i have two charts in another report. and they are the only part of the report that doesnt filter. They just go blank once load is fully complete
thanks Again!