label

[EscapeUK]

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]

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]

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