how do I filter a report

[robrenner]

i am trying to write vb code to track part changes.

i have a table with the fields old part and new part

I need to track part changes over a long period of
time.

so i have the scenario that part A becomes B
then in another record B becomes C
then C becomes D and so on.

i need to write code so that i can select a part on a form and get a report showing me the history of how that part evolved from A to D

I believe i need to use an array but do not know how to use that as a filter for my report.