Subform displays numbers (1 Viewer)

[tjones]

I have a main form and a subform. The main form displays the information as
combo box = column.2 (in other words it shows the actual word not recordid
y/n checkbox = obviously shows which is checked

however the subform shows
combobox = 1 or 2 etc the recordid
y/n check box 1 for yes 2 for no

How do I get the subform to display the words instead of numbers? (can live with the Y/N)

have basically the same issue with a split form (combo only) shows words and datasheet view shows corresponding record id number

tried using =[coffeetype].[column.2] on both the subform and split form datasheet but doesn't work.

 

[veraloopy]

There may be an easier way to do this but I tend to use the 'On Current' event on the form or subform and have a select code like this:

Select Case me.fieldname
Case Is 1 
forms!mainform!subform!fieldname = "Yes"
Case Is 2
forms!mainform!subform!fieldname = "No"
End Select

You would need to put your own form names and field names in place

As i say, there may be an easier way but this works for me