Reference a column on my report!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report is filtered by the information I select on my form. I have a combo
box that has 2 columns Names and NamesID..
On my report I have unbound textbox with the following infor
Forms![MyFormName]![ComboboxName]
But the infomation, when previewed on the report shows the NamesID, I would
like it to show the Names instead of the ID How do I do that?
 
You can do a couple of things. You can make a combobox on the report simular
to the one on the form, but set the width for the ID column to 0. You could
put the following in you textbox: = Dlookup("Names","NamesTable","[NamesID] =
" & Forms![MyFormName]![ComboboxName])
 
Thanks that worked perfect!

Ofer said:
Try

=Forms![MyFormName]![ComboboxName].column(1)

The column number start from 0
--
\\// Live Long and Prosper \\//
BS"D


JOM said:
My report is filtered by the information I select on my form. I have a combo
box that has 2 columns Names and NamesID..
On my report I have unbound textbox with the following infor
Forms![MyFormName]![ComboboxName]
But the infomation, when previewed on the report shows the NamesID, I would
like it to show the Names instead of the ID How do I do that?
Click to expand...
Click to expand...
 
Back
Top