User PIN Report

[merciless32]

ok...I have 23 tables in this database. Each one has a User_ID field in it. I created another table that contains the various USER ID numbers. I would like a report that lists the IDs in a column and the table in which they appear in a row. I used a query at first and it works but is terribly slow so I need code. I know it will have DLookup involved, but I'm unclear about the specifics.

A little help?

Thanks in advance.