add the memo to your main form query (or make it unbound from the main form and just bound to the memo query) and then on an after update event use requery on the subform control.
My Main form is based on Table not query, I created unbound-text box, i created a memo query, how to set that query to unbound text box as control source
I have a sub-form on the main form it is OK, but I needed that on my main form to be displayed one field from a sub-form "PcInfo" and that i could it edit (delete, add or edit values there: there are only PC component names)
Then I created unbound text box, created a query, set it as control source, but not works
I think that I'm doing something wrong
Mu sub form is "Continuous Form"
I'm adding it because it is very comfortable to edit pcinfo from main table, in the future i can show or hide it by a command button.
On the sub-form it works perfectly, but I needed it on my Main form..
Is it difficult to solve that problem, I tried many variants,but none of them worked
I noticed something strange:
Everything is working perfectly, but when I'm opening the sub-form it says: Run-Time Error '2452' Expression you Entered has invalid reference to that parent property
That's because your subform loads before the main form and Parent (in the Current event) refers to the main form but at this time it hasn't loaded and thus can't be found. So what you need to do is this:
1. In the property sheet of the subform, remove the word [Event Procedure]. Don't touch the code behind it, leave it as it is.
2. Save and close the subform.
3. In the Current event of the main form put this: