468,527 Members | 2,113 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,527 developers. It's quick & easy.

Only ID is mentioned, I want the text from the same table

On the main form I choosed a position (like manager, secretary...) from
a combo box.

The field in the footer form of another form mentioned the ID of the
position.
How to have the position TEXT mentioned in this field?
I do have a 97 version database (but works with Acc 2003). There is no
Row Source in the field properties.
The field is bounded to the PositionID in the table with PositionID and
Position columns.

When I changed the Bound Column in the table properties there is no
better result.

Bart
Acc2003

Oct 25 '06 #1
1 1318

AA Arens wrote:
On the main form I choosed a position (like manager, secretary...) from
a combo box.

The field in the footer form of another form mentioned the ID of the
position.
How to have the position TEXT mentioned in this field?
I do have a 97 version database (but works with Acc 2003). There is no
Row Source in the field properties.
The field is bounded to the PositionID in the table with PositionID and
Position columns.

When I changed the Bound Column in the table properties there is no
better result.

Bart
Acc2003
Firstly, I can't see how you do not have a row source property. Have
you selected the All tab in the combo bow properties? I would create a
combo box with the wizard. Select your table, Select the field
Position. Sort if needed. Store value in field Position. Give it a
label and finish. That should give you the text Position associated
with PositiionID

Oct 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by rbarkley | last post: by
2 posts views Thread by Mariame | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.