populating text boxes on a report from a form 1

[paulminne]

Hi,

I have a report and a form. I need to populate a number of fields on the report from a number of fields on the form and am unsure how.

If anyone could steer me on the right path, and even let me know if this is possible that would be very helpful.

Thanks...

 

[Eupher]

First, If you're drawing data in the report directly from fields on a form, the form needs to remain open when the report is loaded. Given that, it's easy. The fields that you want to populate in the report will be unbound, probably text boxes. The control source for the unbound text boxes will look something like this:

[Forms]![FormName]![FormFieldName]

So if you have a form named "DataEntry" with a field named "MyField", the control source for the corresponding field in your report would be:

[Forms]![DataEntry]![MyField]

HTH...

Ken S.

 

[paulminne]

Thanks heaps,

This has solved my problem and decreased my frustration levels dramatically.

Cheers..

- Paul