I created this query in designer today and it is called from another form.
Code:
SELECT tblContacts.FirstName, tblContacts.LastName, tblCampaigns.CampaignCode
FROM (tblCampaigns INNER JOIN tblContacts ON tblCampaigns.ID = tblContacts.Campaign_ID) INNER JOIN tblEmailAddresses ON tblContacts.ID = tblEmailAddresses.Contact_ID
WHERE (((tblCampaigns.ID)=[Forms].[frmCampaign].[ID]));
On that form, the user clicks a button, it runs the query where it gets it's criteria from the control named ID on that form.
It works wonderfully, but I'd like to present it in a more pleasing view.
What I'd like to know is, how do I create a form using the results of this query. Basically, it needs to run the query then open the query as a form.
I hope I didn't confuse everyone with the way I worded that.