Using Multi-Line text box to pulls specific records to a report

[PoolHallJunkie]

Greetings,

I'm trying to have users enter multiple IDs from a table into a text box separated by newline chars, and then (once they press a button) have some sort of macro or code read each line and pull a report I've created based on the ID. Is that possible?

Example:

Table

ID	DataPoint1	DataPoint 2	DataPoint 3
1	d1	d4	d7
2	d2	d5	d8
3	d3	d6	d9

---------------------------------------------------------------------------

Text Box (User will enter values and hit OK)

2 3

-----------------------------------------------------------------------------

Report

ID: 2


DataPoint 1: d2
DataPoint 2: d5
DataPoint 3: d8
-------Page Break------------
ID: 3
DataPoint 1: d3
DataPoint 2: d6
DataPoint 3: d9

[ranman256]

Access is built to use tables. Put the entries into a table (1 per line, no CR needed) and access can use a query to process it.
NO CODE NEEDED.

[June7]

Have users enter free form text and use that as criteria to filter a report? That is thinking outside the box but really just making work for everyone. Why should they have to enter the data points anyway? Isn't that data in a table?

There are several ways to accomplish. Ranman's suggestion may be the simplest. Other options:

A yes/no field in table, check the records you want to include in report, apply filter on this field.

Could select the IDs from a multi-select listbox and use those selections as filter criteria. However, this method requires VBA. http://allenbrowne.com/ser-50.html