Building Report off a Form

Hello Knight in Shining Armor,

I've built a form and a report. I would like the report to run off the
selections in the form (the report is running off a query). I've written the
following in the control source for the report: Forms![INPUT]![ID] (my form
name is INPUT and ID is one of the fields names I want to link in). I've
opened my forms, inputted my criteria and run my report to get the following
error messages: "MS Access can't find the field "Forms![INPUT]![ID]".

As it currently stands, all of my field names in the form are either (a)
unbound combo boxes that reference other tables (ie SELECT [tblHIRE&TERM].[ID]
) or (b) text boxes that auto-populate based on the criteria selected in the
unbound combo boxes. Does that have anything to do with my problem?

Since I'm doing something wrong, any ideas on how to troubleshoot would be
much appreciated!

Thanks!

--
Message posted via http://www.accessmonster.com

There are some issues with your statements.
-a report doesn't have a control source.
Controls like text boxes have control sources
Reports have record sources
- Forms![INPUT]![ID] would need to reference a "control"
on a form, not a "field" on a form
- If you want to display a value from a control on a form
on a report, you would set a text box control source to
=Forms!FormName!ControlName

If you want to filter a report based on values in controls on reports, check
out links at http://www.fontstuff.com/access/acctut08.htm

--
Duane Hookom
MS Access MVP
--

"Glencannon4424 via AccessMonster.com" u17590@uwe wrote in message
news:5c0a02b3b3972@uwe...
Hello Knight in Shining Armor,

I've built a form and a report. I would like the report to run off the
selections in the form (the report is running off a query). I've written
the
following in the control source for the report: Forms![INPUT]![ID] (my
form
name is INPUT and ID is one of the fields names I want to link in). I've
opened my forms, inputted my criteria and run my report to get the
following
error messages: "MS Access can't find the field "Forms![INPUT]![ID]".

As it currently stands, all of my field names in the form are either (a)
unbound combo boxes that reference other tables (ie SELECT
[tblHIRE&TERM].[ID]
) or (b) text boxes that auto-populate based on the criteria selected in
the
unbound combo boxes. Does that have anything to do with my problem?

Since I'm doing something wrong, any ideas on how to troubleshoot would be
much appreciated!

Thanks!

--
Message posted via http://www.accessmonster.com