I'm still having difficulty finding stuff in the searches...I need to get better at this with the new site.
How can I copy the value from a concatenated field on a subform (query) to a memo field on the main form?
I've tried a jillion different ways and none of them seem to work.
The subform query concat is a little clunky (doesn't like to update on the subform until main form_current), but seems to work.
In the subform_current event, I ran a recordset update, no main table update.
Also tried an update SQL there instead, but none of them update the main table.
Can you not update a table while it's open?
Maybe I have the wrong event somewhere; it's very confusing to know which event to assign it to.