2007 Report from Form and Query

  • Thread starter chopper7898 via AccessMonster.com
  • Start date
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?
 
C

chopper7898 via AccessMonster.com

I found my mistake, I didn't use Forms, I had just Form in the first set of
brackets.
Drives me crazy sometimes, but it's well worth it at work, it makes my job
much easier when I have a database for my reports.

Thanks to everyone.
I'm not done with it, but close, and I'm always tweaking it to make it better!


[Forms]![frm_MainForm]![ProjectID]
[Forms]![frm_MainForm]![sfrm_Report]![ReportNumber]

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top