Linking data in a form text box to a report

[timjoost]

I am creating a database to manage vendor claims. I have a combo box that
pulls data from a outside database. In the form I have text boxes that
display the other columns that aren't shown in the combo box. I also want to
use those text fields or some other means to display the secondary fields of
the combo box in the form. I have so far been unable to do this. I am
assuming there is a way to do it but I am just not sure how to do it. Let me
know if you need more information!

Thanks,

Tim

 

[Jeff Boyce]

Tim

I'm a bit confused. You posted in the "reports" newsgroup, and your subject
line seems to refer to using data from a form in a report, but there was
nothing in your description than seemed to point to reports.

Is this a forms question?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[timjoost]

Sorry I want to pull the the text boxes/subfields of the combo box and use
them in the report. In my form I put form instead of report.

Thanks,

Tim

Tim

I'm a bit confused. You posted in the "reports" newsgroup, and your subject
line seems to refer to using data from a form in a report, but there was
nothing in your description than seemed to point to reports.

Is this a forms question?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am creating a database to manage vendor claims. I have a combo box that
pulls data from a outside database. In the form I have text boxes that

[quoted text clipped - 10 lines]

Tim

 

[Jeff Boyce]

Tim

To refer to the contents of controls on a form from within a report, in the
Control Source property, use something like:

Forms!YourFormName!YourControlName

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sorry I want to pull the the text boxes/subfields of the combo box and use
them in the report. In my form I put form instead of report.

Thanks,

Tim

Tim

I'm a bit confused. You posted in the "reports" newsgroup, and your
subject
line seems to refer to using data from a form in a report, but there was
nothing in your description than seemed to point to reports.

Is this a forms question?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am creating a database to manage vendor claims. I have a combo box that
pulls data from a outside database. In the form I have text boxes that

[quoted text clipped - 10 lines]

Tim