Hi,
I have a form (frmCustomer) with a subform (frmJobsSubform). From the subform, I have command buttons that allow the user to preview or print an invoice and a proposal. The proposal report is based on qryProposalData, in which the criteria of Job ID is set to [Forms]![frmCustomer]![frmJobsSubform]![JobID]. It is opened in dialog view, only when the form is opened. This has been working correctly for weeks now, and today when I tried it on another computer, with the same version of Access, the report displays no data. I know it has to do with passing the jobID in the query to the report, because if I open the report from the database window (and just type a Job ID when prompted), it works fine.
Is there a better way to accomplish what I am doing here? I can't figure out why it doesn't work now since it did in the past.
Thanks in advance,
RSJ