Hey folks,

I'm quite sure I used to know how to do this and it was really easy,
but I've forgotten and it's driving me nuts. (I hardly ever use
Access.) Here is the situation.

I have a combo box that uses data from MasterList. It has three
columns:

MasterList.ID
MasterList.Name
MasterList.Frequency

..ID is the stored value. The combo box's .AfterUpdate function does
this:

[Me]!Frequency = Me.ComboBox.Column(2)

So, once you've picked you MasterList item, the Frequency box shows
the Frequency. But of course, MasterList.Frequency is a number which
relates to FrequencyList.ID. And of course, what I want to display in
this box is FrequencyList.Name. I'm sure that's ridiculously simple
but I just can't remember how. Argh!

Little help?

Thanks,

-
Elise