Getting display value of lookup column?

[kman42]

How do you programmatically get the display value of a lookup column?

I have a lookup column that works fine, but when I try to get the value through vba, I can only get the bound value (a number). I tried doing it the way I would for a combo box: [field].Column(1), but that didn't work. I need the display value so I can use it in a Dlookup function on another table.

Thanks,
kman

[jzwp11]

When you say "lookup column" do you mean that you have a lookup at the table level? If so you may want to take a look at this site to see why it is not a good idea to have lookups at the table level. Lookups (combo and list boxes) are best left for forms. If the lookup is based on a table, then the best way is to use a query based on the table to get the value you need. Are you trying to do this in code from a form?

[kman42]

Very enlightening. Thanks. I'll rejigger so that the lookup occurs on the form. I was using a datasheet subform, so putting the lookup in the table made it easy. At least until I ran into the limitations you pointed me to.