Display Description

[Candi]

My form has 1 display only text field. The record source for the field is a code field(value ex: 1,2,3). I know what these codes stand for but the users do not know what 1,2,3 mean. I want to display the descriptions for them on screen. The code/descriptions (code 1= purchase) are stored in another table. How would I display the description from a lookup table when the record source for this field is from main data table for the record?

 

[RichO]

How are your tables set up?

Does the table with the descriptions have 2 separate fields, one for the code number and one for the description?

If so you can query the two tables as the record source for your form (provided the field name for the code is indentical in the 2 tables) and the needed field will be available for your text box.

 

[Candi]

Display description

The form is based on main data table. The code table has 2 fields (code,description).
main table data:
ID-11111
name - Thomas
code -1

code table:
code -1
desc - purchase

Form displays all 3 fields from main table, I just want the code text field to display description from codes table. The codes present in main table are present in codes lookup table.
Thanks for your help!

 

[RichO]

Design a query with those 2 tables, and then draw a link between the code fields in the two field lists. Then use that query as the record source for your table. Then you can add the description to the form easily because the field will be accessible directly from the form.