Kamis, 28 Januari 2016

[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 (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar