Hello everyone,

         I'm trying to get information out of a table to place in a report in Access 2003. I have set a control to obtain an ID number according to certain criteria. It successfully returns the ID number but that is all. any ideas on how I would place all the information into the report? Thanks!

How about DLookup inside the code?

You usually create a query and then create the report based on the query. If you use a control to look up a particular column in your table, without flow control, it will return the first record it sees and not move through the records. A query is better.


mmcdonal