How can you create a pop-up dialog box appeared when clicking on a Report, asking for Status which can tell a query to select certain data for the Report?
I have a Transaction table which contains all data inputed from a Form (DataEntry), a query(PPR) and a Report (ReportByStatus). In the Trasaction table, there is a Status field which has “Open, Rejected, RFT..”. I want to create an automatic dialog box asking for entering status when I click to open the ReportByStatus. If I don’t enteranything in the dialog box, the Report will show all data.
Thank you,
Alan.