Design the query you want and save it. Open your form in design view select
the View/Properties from the main menu. Select the data tab. Click the
Recorsource property and select the query you just created as the
recorsource.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.