Preview a report from data in a form - Access 2003
Posted on 2006-06-13
I am having trouble getting a report to preview/print correctly. Since I haven't done Access programming in over a decade, I'm afraid my skills have slipped. Here is what I have: A combo box on a form selects an import date from a list, and then the form only displays the records that match the import date. The Row Source property of the combo box is set as follows:
SELECT tblPermitData.ImportDate FROM tblPermitData GROUP BY tblPermitData.ImportDate ORDER BY tblPermitData.ImportDate
After the date is selected, the user presses a button labeled 'Refresh', which has the On Click event set to:
This all works fine and dandy.
So I put a button on the form for Print Preview, and created a report with the fields I want included. But I can't figure out how to select only the data that is diplayed in the form. Thanks in advance for any help.