Display question

[Peter Paul]

Greetings, I am attempting to do something which I am sure is easy to do, but I cannot get my mind around it. I have a dropdown field which shows codes and a description for the field. I have the field storing the codes, because that is the data which is significant.

However, when a person is reading the report, I do not want them to have to know what the code means. So, I want to have a description field on the form, which automatically populates with the text description for the code.

How can I accomplish this?

As always, thankyou for your assistance,

Peter Paul

 

[Alexandre]

Seems to be a better approach to build a combobox control base on the two fields (key and description) but showing only the description to the user while actually using and storing the key (hidden).
This is a common feature of A2K and you have wizards for this (at the level of controls, but also at the level of the table by using create list).

If your version of access don t have, post and i ll explain how to do it manually.

 

[Peter Paul]

I am using Access 97, so the wizard does not show me how to do this. Thanks in advance for your help

Peter Paul

 

[Peter Paul]

Pat and Andre,
thanks for your help. Unfortunately, I am still not having succcess.

I made the recordsource for the form a query which contained both the control table, and the lookup table.

I created a combo-box which had the control as the Description of the lookup table, which I need displayed.

When I did this, I found that I was not able to change the CODE field from what already existed, and the DESCRIPTION field did not display the proper code, nor could I change the DESCRIPTION field.

Any further assistance would be greatly appreciated, I kow that this can be done, just wish I were a tad smarter.

Thank you again,
Peter Paul