Numbers displayed instead of text

[aattas]

Experts,

1- I have a table that has 4 columns
2- I used a field in a form to locate the second column and insert into the filed.
3- The i created a unbound field to display the third column as Description.
4- the unbound displayed properly as per the table (3rd Column).
5- when i created the query for the main filed, it comes out numbers instead of text as in the form.

Any ideas why did happen.

Muchas Gracias

 

[isladogs]

You are using words like fields and columns incorrectly within the context of Access tables and forms. This makes it hard to understand your meaning.

Tables have fields. Forms have controls that may be unbound or bound to fields.

 

[Gasman]

Sounds to me like you are getting the ID of the combo (2nd column) and not the description (3rd column)

Combos start at 0 as well, so 3rd column is column(2)

HTH

 

[aattas]

gentlemen,

Thankyou for your reply.

Isladogs, you are right , thanks for pointing out. I took a note.

Gasman, thanks for the reply.

I think i found my problem, you guys are my inspiration.

The problem was in the Bound Column, it was 1 and when i changed to 2, all text appeared.

Thanks again guys.

 

[Gasman]

I always have my combos set up as

First field is the bound field and normally the ID of the record. Always hidden.
Next field is the descriptive field
Any others follow on after.

 

[theDBguy]

Hi. I hope I’m wrong, but it sounds to me like you’re using a lookup field at the table level. If so, be careful. You could be in for some more headaches down the road.