This may be easy but I cannot figure it out.
I want to add a user selected date and another user selected word (one of two possible) to a report at runtime. I'd like to use the activeX calender for the date and a toggle button for the word. These are not fields in the particular query used in the report. I could add them but I want to do this to five different reports and would like to pull the data directly from the table if possible. I created a form with these controls and they work fine. I cannot get the variables in my report though. When the user wants to print the report, I'd like the form to open to accept the user selected date and word. When done I'd like the report to open in Preview with the date and word in the proper fields.
Any help would be appreciated