Field Display Troubles

  • Thread starter Thread starter TH
  • Start date Start date
T

TH

I am trying to use a query as the basis for displaying records from two
different tables. Three of the fields are lookup fields. On the form I'm
working on, I want these fields to be displayed as text boxes instead of the
combo boxes they normally are. I went to the query and changed the display
control property on the look up tab to Text Box. The problem is now I am
seeing numbers (the corresponding ID fields) in the fields instead of words
like I want. How do I get my form to display a text box with the words
instead of numbers? Does it have something to do with the fact that when I
used the wizard to create the look up field "Hidden Key Column" was checked?
It was recommended and I couldn't figure out what it was so I left it
checked.

Thanks for the help.
 
If you want to see the other values, you will need to set your field back to
a combo box. The combo box is used to show other field data from a table
such as Lastname, FirstName rather than say 23. Otherwise you get the
Primary Key value from the table. If you don't set it back to a combo box,
then your user will have to guess at the correct number when adding a new
record. The combo box pick ensure the correct record will be chosen.
 
Thanks for answering. The reason that I didn't want this form to show the
combo box is because this form is not where editing will occur. It is just
a place to select which records the user wants to print. However, I guess
I'll have to leave it as combo boxes. Drats! Thanks again.

Tonye
 
I just had a thought. Why can I see text in the query when I change the
display property control on the lookup tab (of the property sheet) but when
I try to display the information on the form I see numbers?

Tonye
 
Thank you for replying. I tried to add the tables that are the source of
the lookup fields and the query returned no results. Also, the form based
on this query was completely blank. So I decided to change the look up
fields to regular fields and now I'm all set. Thanks.

Tonye
 
Back
Top