I have a form displaying a subform. One of the columns in my subform is a memo field for notes. It is not practical to show that column on the subform so I hide it. This is what I would like to do. I would like to have a text box or label on my main form which displays the contents of the memo field of the current record selected in the subform. I hope you got all of that. How can I do that? I know some basic VB and I can write SQL if needed.

Thanks

Why not bound the form to a query that contains the memo field you are talking about. Then you can just display the memo field on the form instead of the subform.

That is the easiest way I can think of.

Kristen

I may be able to do it by assigning a value to a global variable on the current selection of the subform. Then set the label on the main form to equal the global variable. Then refresh the main form. Is that an efficient way to do it? Does it sound like it would even work?