Displaying data from autopopulating unbound text boxes in reports

[LosLobo]

Hello all:

I'm sure that this has been asked and answered many times over here, but after a week of scouring dozens of help forums on the internet for an answer I was too lazy to search again here.

I have a form that contains an unbound text box that autopopulates based on data entered in a combobox. I built a query to pull the autopopulating data from a different table than my "main" table....and it works fine. The autopopulating text box displays the data in the form, but not in the table it is linked to. I understand that is normal because the text box is "unbound" and it is not a big concern.



Now....my problem. I want to set up a button on my form that will open a report showing all the fields in my form, including the unbound autopopulating text box, and I can't get it to work. I've tried literally dozens of pieces of VBA code based on my internet searches, and nothing is getting the job done.

I'm sure you'll want more details on this, so if you think you can help please reply and I look forward to working with you!

Thanks!

[rpeare]

copy and paste the control from your form to the report and in the CONTROL SOURCE of the object on the report put

=forms!formname!autofill_fieldname

where formname is the actual name of your form and autofill_fieldname is the name of the control that has the value you want on your form.

This assumes the form will be open when you open the report as well.

[LosLobo]

copy and paste the control from your form to the report and in the CONTROL SOURCE of the object on the report put

=forms!formname!autofill_fieldname

where formname is the actual name of your form and autofill_fieldname is the name of the control that has the value you want on your form.

This assumes the form will be open when you open the report as well.

Thank you for that suggestion! I will try it first thing in the morning when I get into my office and let you know how it went.

[LosLobo]

copy and paste the control from your form to the report and in the CONTROL SOURCE of the object on the report put

=forms!formname!autofill_fieldname

where formname is the actual name of your form and autofill_fieldname is the name of the control that has the value you want on your form.

This assumes the form will be open when you open the report as well.

It looks like that did the trick!!

Thank you for saving me from losing any more hair....I really appreciate the assist!