subform showing numbers rather than words

[tjones]

How do you get a subform to show data words instead of the numbers for the combo box it represents.

 

[sneuberg]

The Column Widths determine what you see. Typically where there is a ID field they are set to

0";1"

which would display the second column. Usually the Id number is in the first. Also make sure the Column Count is correct, i.e., equal to the total number of columns you want to displayed or will reference

 

[tjones]

I forgot to say that information is being pulled with a query so when i try and put in two column widths i get an error.

 

[sneuberg]

How many columns does the query return? What 's the error you are getting?

Maybe it would be better if you uploaded your database so we can see how this is set up.

 

[CJ_London]

I think you are saying you are using a query as a sourceobject to a subform. If so...

You need to change text boxes to comboboxes if you want to display the text and edit the data or join the other tables in your query (but then the subform will not be editable).

Using queries as subform controlsources is OK, but you can't change textboxes to comboboxes - to do that you need to use a form (which can be datasheet view).

Alternatively you can try setting your fields to lookups - but that is really not a good idea. It may be fine in this instance, but it will soon trip you up somewhere else.