I have a form with 6 date fields and each date field has a command button. The user clicks the Command button, which then fills in the date field and calls a procedure within the form, passing an an argument (1-6) so the procedure know which field was updated. The procedure does some things and then calls a report, passing the field number as an .openargs. In the Report Activate section, I have a Case Select statement that populates two fields on the report (the date field and name). I also do a couple of lookups in this section as well to fill in some fields. The problem is that it works okay when I call the report in a Preview mode but not when I directly print it. When I directly print only fields from the underlying table are shown, none of the lookups etc.
I would appreciate it if someone knows why Access works this way.