Duane,
I wish I could follow you but I am not quite smart enough. I think I need a few more details to help me understand. I am not quite able to understand the concept.
Thanks,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, January 28, 2016 4:57 PM
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Combo to Text
You can add text boxes (invisible) with control sources of:
=cboBoxName1.Column(1)
=cboBoxName2.Column(1)
Then, in the report, use the names of the text boxes rather than the names of the combo boxes.
Duane
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Jan 2016 15:08:55 -0600
Subject: [MS_AccessPros] Combo to Text
I have a few unbound fields on a form. Once the fields are filled in the user can click a button and a report opens with some of the fields already populated with the text from the unbound fields on the form. It was actually working pretty good until I changed a few of the unbound filed to Combo boxes. Now the user selects a value from the combo box. However when the report is opened I am getting an error, which I expected. What I want is to still show the text attached to the number behind the combo box.
So agent 2 is Bill, based on the table the combo box uses, If “Bill” is selected from the combo box, I know the value the combo box is holding is “2” which is what I want, but is there any way to open a form and pull the text “Bill” rather than the value 2?
There is no query or table behind the form as I do not want to store the values there. The unbound field will also be use to append some of the data to other tables, which is why I need the combo boxes, as that matches the data type of the table the data may be moved to.
Thanks,
Bill
Access 2013
Minnesota, USA
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar