Display field relating to control source property

[ktrasler]

Hi all

is there a way to display a relating field to a control source property in a report.

e.g

Controlsource = TeamLeader

Teamleader is a lookup in my table from TLno/ TLname. bound column to 1, column count to 2, width to 0;2.5cm (so only the name is displayed in the table but the control is the TLno.

my report will only display the TLno but I want it to display the name.

something like controlsource = Teamleader.column(2) - obviously this doesn't work.

I suppose the other way round it would be to include all the name fields in my query. although thought there might be another way.

Hope this makes sense. Kind of hard to explain.

Cheers

Kev

 

[Dennisk]

General principle, do not use combo box's in a report. Add the LU table to the underlying query and return the description not the code.