If you mean to pick say a persons id or name from a list and then display the
information related to that person, you can do it via a subform. You have
your main table related to another table via a foreign key and then the
subform automatically displays matching rows in the related table. There is a
lot of information about subforms in Access Help.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"egoodson" wrote:

I would like to be able to pull one word from the drop down box in a form or
report and it pull up that person's information. Is this possible?