based on these tables
http://oi40.tinypic.com/2n0ijw9.jpg
top one is Customers table
bottom one is Orders table
what would the code be in a command button (userform) that will display all orders for a selected customer. This should include an option to view the result on a temporary worksheet, and also a “Print” button on the worksheet to preview the worksheet.
Bookmarks