My database consists on just one table (part numbers, and information about it). I have a form that is used to search part numbers. I made a search button with VBA with this code:



Code:
DoCmd.OpenQuery "searchquery", acViewNormal, acReadOnly
where when you fill in the textboxes for what you want to search, a query is used to search my main table for those. With the code that I have, it will bring up another table that lists what I searched for.

I am looking at instead of displaying it in a table, i want it to display in a form that has textboxes in a specific format (basically only shows one part at a time, rather than a list).

Can you help me figure out how to link my search and query to the other form that I want my results to show up?? Or can you tell me how to make just one form with textboxes and I can input what I want to search into them, and then the results will show up one by one in the same textbox, using the query that I have??

Thanks