Combo box reference

[Guest]

I have a number of combo boxes on my forms that we use to select info sourced
from tables as usual. Problem is I cant get the values that they selected to
show in a report or bound source. Only seem to get the ID ref number showing
that is kept in the source field once an option has been selected. How can I
get the report to source the info represented by the ID number which at
present is displayed. Query? Expression Builder? Please help!!
eg i choose and exercise from a choice of 5, table stores that as its
exerciseID number. When I try to do a report of my details all i get is the
ID number showing on report.
Regards
Paul

 

[Guest]

Link the lookup table in your query for the report. Output the value and not
the ID.

 

[Guest]

This has helped to a certain extent I just have one more lingering prob. I
have a form called terms and conditions which refs the client name and todays
date no probs, but i still cant get it pull up the PTs name even though i
have a lookup field and it stores the PTs name in that field. When I control
source it to that point on the form and open my terms and conditions for it
still displays the PTID number, even though it doesnt show in the field
source?
Thanks again

 

[Guest]

You lost me here.

This has helped to a certain extent I just have one more lingering prob. I
have a form called terms and conditions which refs the client name and todays
date no probs, but i still cant get it pull up the PTs name even though i
have a lookup field and it stores the PTs name in that field. When I control
source it to that point on the form and open my terms and conditions for it
still displays the PTID number, even though it doesnt show in the field
source?
Thanks again

 

[Guest]

I have a form which includes a word file called terms and conditions. On this
file Ive decided to include control sources where it fills in three balnk
spaces. Client name, Trainer name and current date. Although I have a lookup
filed tha displays the right field text it still displays the ID number on
the report although it displays the correct ref for client name from the same
form. I must say that client name is an input file, Trainer is a combo box
choice.

Many thanks
Paul

 

[Guest]

Join the lookup file in your report query and pull down the description for
the report.