Copying a field from a subform to a textbox

[Hawkide]

I have a form named myForm

There is a subform named mySubForm on myForm

I want to put a textbox on myForm that displays the Comments field from the current record of the mySubForm

I am struggling. TIA...

 

[Blorf]

Hi.

On the on current event of your sub form, maybe add something like

Forms!MyForm!MyTextbox = me.Comment

That way, when you move from record to record in your subform, it will trigger the update.

ChaZ

 

[Hawkide]

Thanks...Works great

 

[Blorf]

Glad to help.