help formatting/printing report to act as form

[reservedbcreater]

can someone help me to do this.........

i have 17 forms - they act as a survey

if a user wants to print the survey out for a certain record #....it has
to print all 17 forms all filled out for that record........

i hear printing forms doesnt work - so how would i make a report do what i
want? - i copy and paste the form design for each form to a different
report?? or all to one report somehow???????

i created one report by copy and pasting first form's design. but all i
get when i looked at the form was every field was filled out with
???name???? or something.......i want it to be filled out survey forms
that u can browse throguh record #s with mouse wheel

 

[Rick B]

As posted in your previous message, it does not sound like you have a
normalized table structure.

But, Just build a query that pulls all 17 tables. they should all have the
same primary key, so you should be able to relate each record to one
another.

Create a report based on this query.

It should be one long report with each "question" and answer.

Rick B

 

[reservedbcreater]

but i want the physical format fo the report to be exactly the same as the
form?

 

[Rick B]

Then make it look exactly the same.

 

[Penguin]

Also if you right-click on the form you want as a report select save
as report but the best way is to create a new report.

 

[reservedbcreater]

thanks