Can text boxes show data from elsewhere (1 Viewer)

[rosst]

I have a report which is bound to a query which gets its values from combo boxes on a form. In the title of the report I want to display what the combo boxes were set to. One of the combo boxes actually retrieves a different value from the one shown in the combo box (because of bound column No. and column widths.) The displayed value is meaninful to users and it is this value I want to display in the report heading. Can I set up a text box to get this value from a second query which also uses the combo box on the same form or am I obliged to use a bound subform? Any tips would be most appreciated.

 

[chrismcbride]

One of two ways to do this would be to use the Column property of the Combo box. In other words colums other than the bound column can be referenced like this...

Forms!frmWhatever!cboComboBox.Column(1)

This would refer to the first visible column in the ComboBox called cboComboBox

The other way would be to use DLookup. Check the Help file for this, if you would like. However this way would not be as efficient.
Good Luck
Chris