Hi All,
There is quite a lot of info around this out there, but I have been unale to solve my issue.
I have a parent form with a child subform.
On the parent form:
I have a textbox which the after update property includes a vba query to update a list box.
There is no .requery instruction
There is no interaction with the subform at this point
The subform has no requery property or code associated with it
However every time I hit return on the textbox to run the query to populate the listbox the subform requeries.
I would really prefer to keep the parent child links in tact if possible (some online suggestions include the removal of these).
Anyone have any ideas?
There is quite a lot of info around this out there, but I have been unale to solve my issue.
I have a parent form with a child subform.
On the parent form:
I have a textbox which the after update property includes a vba query to update a list box.
There is no .requery instruction
There is no interaction with the subform at this point
The subform has no requery property or code associated with it
However every time I hit return on the textbox to run the query to populate the listbox the subform requeries.
I would really prefer to keep the parent child links in tact if possible (some online suggestions include the removal of these).
Anyone have any ideas?