Only display specified records

[The Odyssey]

Is it possible to only display a specific number of records with multiple filters of the same field.

So say I have a table with 2 Columns:

Name
Address

Can a user basically search for multiple records based off of their names? Maybe by using a form where they can input those names like this:

John Smith
Dave Richardson
Sophie Parker

Then the report will only display the records containing those names.

Hope this made sense, many thanks.

 

[pr2-eugin]

You can, is the straight forward answer. Although how you want to achieve it is a different question. Normally, you would have to use a Form, with several Text Boxes for each name, however, this could be overcome by using VBA - but you need to do some looping and coding.

 

[The Odyssey]

The way it is achieved does not really matter, I only used the form as an example to help portray what I meant

I want to apply this to an already existing report. Basically I want users to have the option to do this, but I just don't know how design the feature.

 

[The Odyssey]

Does anyone know how to achieve this and can you give me an idea of what code is needed?

Google doesn't help with this at all so I don't really have any other options.

 

[Jarod]

Hello Odyssey, have you had any success in this matter ? I think I need the same thing.
I would like to display a selection of records on one form. Basically I need to be able to show on one form the records of 30ish customers everyday from a database of 900 customers (they come for appointments).
It's somewhere around multiple items form and continuous forms but I can't seem to figure it out.

 

[jdraw]

Martin Green has a number of Access related tutorials. Here is one that deals with creating dynamic reports.

Good luck.