I have a very basic structure, two tables. I have buyers and their basic details in one table. I have the items they bought in another table. I can make a form off of the buyers table with a subform listing the items bought. I want to be able to click the 'open form' command button on my switchboard and have a parameter query or something equal come up so I can see the items bought by the individual buyer in the form when it opens. I have tried to make a parameter query but it always makes the number of records equal to the number of items purchased. So, when I get to the form then i have to go through a few records to see all the items. There must be a way. I can get the form I want by making it off the buyers table because the subdatasheet then becomes the subform, but that is without the parameter and I don't want to search through all the records to come up with the right buyer every tine. I know there is a way. I have searched this forum and others and can't find an answer to my question. Please help.