Report Based on Form Data

[JD McLeod]

I have a form that the user enters some data into, and then based on what
they enter, the form has text fields that lookup in other tables certain
pieces of data and displays on the form. These looked up pieces of data are
not saved in the table that the form is based on. I now need to create a
report that shows both the data entered on the form (which is saved in a
table) and the looked up pieces of data that are just displayed on the form.
How should I go about doing this? Will i have to create those same lookup
formulas on my report or is there a way to create a report based on a form?
Everything i read said not to save duplicate information in multiple tables,
so i didn't have the form's table source save those looked up data items.
That would have been simple because, i could have then based my report on
that table. Any help would be appreciated.

 

[J Sedoff]

I believe you should be able to create a query based on your table and use
the data entered on the form as a query parameter
(Forms!FormName!ControlName) then create a report based on that query.