Dsplaying memo data in text box?

[NewShoes]

Hey all,

I have a combo box on my main form with a few text boxes under it. I can easily populate these text boxes with info related to the combobox box by using the column method. However, because one of the fields is a memo field, it wont be included in the combo box. Is there an alternative way to populate a text box with the memo field data?

Many thanks,
-NS

 

[John Big Booty]

You could use the DLookup() function to populate your Memo field based on the current ID help by the Combo Box.

You could also make the Memo field a part of the Row Source of the Combo, this column doesn't have to be visible in the Combo though.

 

[NewShoes]

Many thanks John, I will give this a try.