Filtering

[txdon32]

I want to create a report that filters by "Name". Can you help me with the event procedure that asks the user to "Enter Name" when the user tries to open the report. I think I'm close but I just can't get over the proverbial "hump". All help is greatly appreciated!


txdon32

 

[jfgambit]

Assuming that your report is based on a query, then add the following to the Name field criteria:

[What is user Name?]

Now, the problem stems from the fact that not everyone may know how to spell the name correctly...so you could do:

Like "*" & [What is User Name] & "*"

But, if you have a Smith and a Smithers...then you will get both on your report.

So...you could create a form that has a combobox based of your Name table, include the UniqueID for the record and the name of the individual. Add a command button to open the report and finally, add the following to the UniqueID criteria of the query that runs the report:

[Forms]![NameofForm]![NameComboBox]

Obviously, you will need to change the names to match those in your database.

HTH

 

[txdon32]

Let me clarify the question

OK, so I wasn't very clear and that's my fault

Let's say there are 50 families stored on my database and I want to track the activities of the "Williams". I want the report to ask the user to "Enter Family Name" when the report is opened. After the user enters a vaild name, the report should generate all the activities of the "Williams".


Hopefully this clarifies the question but thank you for you timely response anyway!


txdon32

 

[jfgambit]

Then I would follow this recommendation:

Assuming that your report is based on a query, then add the following to the Name field criteria:

[What is user Name?]

 

[txdon32]

thanks!

It worked!

Thanks