Updateable control for unjoined table 1

[freddydog]

Hi, I have a form with different pages containing continuous form information (mailing list). In the heading of the page, I would like to add a control where the User can add comments, notes i.e. updateable control. These comments/notes would be stored in a table not joined to the table containing the mailing list information.
I've tried a dlookup which works and retrieves the comment column but it's not updateable.
Thanks

 

[Remou]

I suppose the easiest thing to do would be to run an update query in a suitable event.

 

[Remou]

I should have mentioned that you should set the contents of the control to the value of the DlookUp in say, the Current event for the form, but leave the control unbound.

 

[freddydog]

Remou, thanks for the advice, it works great!