C
chopper7898 via AccessMonster.com
I'm having a difficult time, done this in 2003 and using the old as a sample
but still not getting a report based from fields on my form.
I have two forms, frm_MainForm and sfrm_Report, I'm trying to base my report
from a query.
The forms are based on two tables and linked by ProjectID (autonumber)
The query has both tables in it. and I'm trying to use two criteria ProjectID
and ReportNumber to base the reports on with a command button on the subform
to open the report in print preview for the current report. I'am using the
following in the query:
[Form]![frm_MainForm]![ProjectID]
[Form]![frm_MainForm]![sfrm_Report]![ReportNumber]
I just keep getting Parameter enter value popup.
I have almost the same in a 2003 and it works.
Does 2007 have different settings?
but still not getting a report based from fields on my form.
I have two forms, frm_MainForm and sfrm_Report, I'm trying to base my report
from a query.
The forms are based on two tables and linked by ProjectID (autonumber)
The query has both tables in it. and I'm trying to use two criteria ProjectID
and ReportNumber to base the reports on with a command button on the subform
to open the report in print preview for the current report. I'am using the
following in the query:
[Form]![frm_MainForm]![ProjectID]
[Form]![frm_MainForm]![sfrm_Report]![ReportNumber]
I just keep getting Parameter enter value popup.
I have almost the same in a 2003 and it works.
Does 2007 have different settings?