Display labels instead of values in a subform datasheet

[username29]

I think the solution to this question is to use a lookup table, but I am an Access beginner so please go slowly.

I have a subform that is displayed as a datasheet, and the source of this data is from another database. Essentially, it shows someone's name and status, but the status is displayed as a number. The people using the database don't know what this value means, so I was asked to display the label instead.

The values still need to remain in the database where the data resides, but can I use a lookup table or some other mechanism so that the label is displayed in the database the users are viewing? How exactly do I do this?

Ie...the data below resides in Database A but is displayed in Database B:
Col1 | Col2 | Col3
John | Smith | 2
Jane | Doe | 1

And in Database B only, it should show as:
Col1 | Col2 | Col3
John | Smith | Inactive
Jane | Doe | Active



Note that the users of Database B will not be updating Col3 data, they will just be viewing it.

Thanks in advance!!

[June7]

Options:

1. If Col3 is a Yes/No field, set Format property to display Active/Inactive - since you show values 1 and 2 I presume this is not a Yes/No field, so continue to next option

2. multi-column combobox http://www.datapigtechnologies.com/f...combobox3.html
RowSource can pull values from table or can be ValueList typed into the RowSource

3. include the lookup table in form RecordSource
set join type as "Retrieve all records from {data table name} and only those from {lookup table name} that match
bind textboxes to the lookup field and set as Locked Yes, TabStop No

4. IIf() or Switch() or Choose() expression in query or textbox

5. DLookup() function