Subform and ListBox

[GM]

I have a subform. I have lisbox bound to a field on the
subform. The field on the subform contains the day number
of the week (i.e. 1 for Sun and 7 for Sat). I have a table
that has the day number of week and dayname of week (i.e.
1,Sun). The two tables do have a relationship in the
Access database. When I add a lisbox to the subform and
bind it to the field on the subform, I do not get the
dayname but the day number (i.e. 1). Why does the listbox
not work on the subform as it does on just about any other
type of form. Please advise.

Thanks,
GM

 

[Steve Schapel]

GM,

The effect you are seeking depends on the correct settings for the Row
Source, Column Count, Bound Column, and Column Widths properties of the
Listbox. Please post back if you need more specific help with this.