Fields show differently in table versus form.

[zero3ree]

I have a table that gets put into a sub form and in the sub form the work hours.project ID shows work hours.ID and not the work hours.project ID. I cant figure it out.

I made a couple images.

How it shows in table,

How it shows in sub form,

It is just set to show project ID as control source.

Any help would be greatly appreciated.

[ssanfu]

In the table design, are any of the fields set up as a look up field?
Something like this?
Attachment 8665
If so, you should read this:
http://access.mvps.org/access/search.htm

and this:
http://access.mvps.org/access/lookupfields.htm