Control Source not returning expected value

[Guest]

I have a table Table1 that has a field whose value is a Lookup using a Combo
Box. The bound field is 1 (that is the AutoNumber) and the Column Count is 2
and widths 0";2"

When I make a query of the table Table1 I see field 2 (the Description)
which is what I want ... but when I make a form and use that field from the
query in the Control Source for a form/textbox I get the bound value (ie the
Autonumber).

How do I make it so field 2 (ie the Description Field) will show in the form
and not the bound field.

Thank you for your help.

Steven

 

[Douglas J. Steele]

That's one of the many reasons why so many of us dislike lookup fields. (see
http://www.mvps.org/access/lookupfields.htm for more reasons)

While it may appear to you that the description is in Table1, it isn't: all
that's been stored there is the Id. You'll need to create a query that joins
the two tables, and use that query if you want the description.