How Can IDisplay Field From Form On Report?? (1 Viewer)

[Marcus H]

In my quote form i have a lookup box that looks up brokers from the broker table. I have also created a field using a combo box that automatically enteres the fax number of the broker on my quote form from selecting the broker in the lookup table.

Now i want to create a report that names the broker and the the broker fax number. However because the broker fax number was not a field in my quote table i can't seem to be able to get it into my report like on my form. Is there a way of getting this field onto my report? THanks for any help!

 

[Chris RR]

Set up a text field with a control source like this, assuming fMyForm is your form and txtBrokerFax is the field on that form that you want. You will need to have the form open (but it can be minimized) when you preview the report.

Here goes:
=[Forms]![fMyForm]![txtBrokerFax]

 

[Pat Hartman]

Change the recordsource of the report to a query that joins to the broker table to pick up the fax number and the broker name.