forms not appearing on the details

[trident]

I made a form that i am trying to create a report that when I print, everything on the form I made should be shown on the report.

1form - This shows brand, model, quantity, delivery date
2form - this shows the model and serial number to be delivered
3form - this shows other details such as warranty and items
4form - this is the remarks that needs to appear on the report as well

1form and 2form, appears in the report because the default view is DATASHEET
3form and 4form, is not appearing as above, the default view is SINGLE FORM, which should be



I tried changing the default view to DATASHEET, and the details appeared, however, i do not want this to be seen as an excel list. There is a format that is arranged in the form that needs to be printed.

Please help me on figuring this out.

Thank you.

Trident

[ranman256]

Make a report, not a formReport.
use the keys on the form in the query,to open the report.

select * from table where [key]=forms!myForm!txtID

[orange]

???Not following your post.
Data is stored in tables. Forms and reports act like a window(s) onto those tables.
Forms by themselves do not store data.
Please tell us more about the tables involved, or show a graphic of the table designs.