Convert a filled in form into report

[djgeverson]

Hi there,

I have a form that I want users to fill in and then on a button click have that information entered in the active form turned into a report. I can only find ways to export entire sections of data into reports not individual active form windows! Help anyone!

[topher23]

The best way to do this is to have your form fill in a table with a unique record ID, then when the user clicks the button, save the record and pass the record's ID number from the form as filter criteria to the report, which is also pulling its data from the same table the user just entered the data into. Forms and reports don't actually "hold" the data, the data should always be held in one or more tables. If you don't want the data saved, use a temporary table that is deleted after it is used. This is a very basic answer, but from your question it appears you might be at pre- Access 101 level. Feel free to correct me if I'm wrong on that.

[NeoPa]

That sounds spot on to me. Well explained Topher.