Populate report from form data

[Channah]

Is it possible to populate a report using the current data in a form?
I would like to be able to generate a report based on a form that shows account details. The form is controlled from other forms that supply data and open through scripts.

Any ideas on this would be greatly appreciated.
Thanks,

Chris

 

[jjob]

I'm not at an Access PC at the moment so I can't check what I am about to suggest, but I'm fairly certain that you can open a report with a 'filter' value, just as you can open a form with one. So if you have an autonumber (or any key ) field, then you can use DoCmd to open the report and set the filter value to the key field, this should only show the one, current record, if you set the filter to 'Me.id' or whatever you call the key field. (I always call my autonumber key fields 'id'.)

 

[cykopat]

If you looking to populate a report based off an OPEN form. Just create unbound txtboxes in your report and have them point to the form fields..

=Forms!FormName!Field

That will populate the report..