label

EscapeUK · Oct 25, 2000

I a form i get the user to select a value from a combo box or it might be a list. It uses to fields the id number and the text, but only the text is displayed.

I want the item selected to be displayed on a report in a label. However when I try this the number of the text item selected is displayed.

kathryn · Oct 25, 2000

That's because the actual value of the control is the ID field. To access the text value, you need to use the columns property, I believe. Look at the help topic "Column Property" in the help file.

Kathryn

Rohdem · Oct 27, 2000

if you don't want to change the bound column, you could try a dlookup:

me.label = dlookup("textfield", "tblwhatever", "id = '" & idnameonreport & "'"

Mike Rohde
rohdem@marshallengines.com

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!

label

EscapeUK

Programmer

kathryn

Programmer

Rohdem

Programmer

Similar threads

Part and Inventory Search

Sponsor