S
Stephane Pelletier
Hi everyone,
I've just create a form with a sub form, this subform also have a sub form.
Now every field of form,subform and sub subform are all related to a source
that is control via query.
The current picture of the process is simple: Mother form gives all
information on a client (Name, project, address, etc) ... The child form
gives all information on every report we make for that client (Report
numbert, technician who made the report, date, etc) (Note: relation one to
many) and finally the child child form is giving us all the test that have
been done for a specific report (Test number, description and so on) (Again
relation one to many between child form and chil child form)
Here's where my is: I've created a button to search for another report from
the same Client. I know for a fact that all query are running properly but
Form are still showing the data from the previous query. How can I refresh
every thing.
In my book, since every field have a source on a specific query, if I change
the data in the underlaying query (Not the query itself just the data) it
should also change the display on the forms.
I know that there is a way to do so (I just dont know which one yet) cause
If I close the form and re-open it ... well the new data will be on display.
So Again How can I show the proper data without closing the form ?
Thanks for your Helps
Stephane Pelletier
I've just create a form with a sub form, this subform also have a sub form.
Now every field of form,subform and sub subform are all related to a source
that is control via query.
The current picture of the process is simple: Mother form gives all
information on a client (Name, project, address, etc) ... The child form
gives all information on every report we make for that client (Report
numbert, technician who made the report, date, etc) (Note: relation one to
many) and finally the child child form is giving us all the test that have
been done for a specific report (Test number, description and so on) (Again
relation one to many between child form and chil child form)
Here's where my is: I've created a button to search for another report from
the same Client. I know for a fact that all query are running properly but
Form are still showing the data from the previous query. How can I refresh
every thing.
In my book, since every field have a source on a specific query, if I change
the data in the underlaying query (Not the query itself just the data) it
should also change the display on the forms.
I know that there is a way to do so (I just dont know which one yet) cause
If I close the form and re-open it ... well the new data will be on display.
So Again How can I show the proper data without closing the form ?
Thanks for your Helps
Stephane Pelletier