Updating data in a subform when tables change.
Please forgive me if this seems like a simple problem.
I have two forms (A and B). B is a subform which is linked to A through a many-to-one relationship (Table A and B respectively). In creating my mini-application I have chosen to used ADO to write data to the underlying tables. Hence, when data on Form A changes i manualy write the data to the table. It is at this point that I now begin to add data to Table B.
When opening the form I am able to see all the data in the subform B which is related to the fields referenced in the mainform A by just going from one record in A to the next.
The problem is when I am creating the new data in table B I want it to be refreshed in subform B immediately and I am not sure how to do this.