Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recieve selected text from combo box in form

Status
Not open for further replies.

JDK9AB

Technical User
Feb 3, 2003
9
US
I created a form for my users to use. Now they need that form exported to word just as it appears on the screen. Obviously the only way to do that is to make a report from it and export the report. So I am trying to pull the selected values from my combo boxes in the form to a text box or label. However, for some reason, the report will only be able to grab the value of the last combo box I edited before going to the form. All the other values come up #error. I am assuming this happens because the other combo boxes don't have the focus and therefore their text values can't be viewed or changed.

If someone could help me get around this, I would be very greatful.

Justin
 
Sorry to everyone who had to read this, I was just not using my brain. I kept trying to view it as a variable in VBA instead of as a form entry. In the control source on the textboxes in the form, I was typing Forms!ScheduleReport!combo50.Text instead of [Forms]![ScheduleReport]![combo50]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top