Let A Report Display A Forms Current Record

[GussyBoy]

I want to call a report from a form and have it display the current record on the form.

Please Help.

Thanks.

 

[raymondo]

You can set a filter in the reports OnOpen event that selects only the record in your form.

 

[zambezibill]

In addition to Raymondo's suggestion, you can handle it from the query that provides the report's recordset.

Open the query in design view, select the key field (the one that will distinguish the record in both the form and report) and then set its critieria to:

Forms!YourFormName!ControlName

The control name will be for the control (text box, listbox, combobox) that is bound to the key field.

The report will now only show records related to the form's current record.

Cheers, Bill

 

[zambezibill]

In addition to Raymondo's suggestion, you can handle it from the query that provides the report's recordset.

Open the query in design view, select the key field (the one that will distinguish the record in both the form and report) and then set its critieria to:

Forms!YourFormName!ControlName

The control name will be for the control (text box, listbox, combobox) that is bound to the key field.

The report will now only show records related to the form's current record.

Cheers, Bill