Associating a secondary form

[kupe]

The main form (frmMain) is fed by qryMain. I'd like to put a memo field on a separate form (frmMemoField) to avoid cluttering the main form.

Is there a way to ensure that frmMemoField offers the same record currently displayed on frmMain, please, Experts?

 

[Mile-O]

Put a hidden field on the original form. Bind this to the memo field.

Create an unbound form for your memo. If the hidden field has a value, get the value from it and put it in the memo box. On closing the second form assign the value of the unbound textbox to the hidden textbox on the main form.

 

[kupe]

Excellent, MoP. Many thanks. Good to hear from you. Cheers.