I have a continuous form who's record source us a query I use for summarising data in the form detail.
In the form header there are some controls for the user to add new data. Usually this opens a pop up form, where the user will add the new data then I updates the underlying tables using code.
When the pop up form closes, I use Forms!Form.Requery to requery the main form so the new data shows in the main form detail.
The problem is doesn't! The user has to wait until he adds more data, when the previous data will then show or I put in a manual button for the user to reqery the form.
I've been trying to resolve this for a while bit not found a solution that works consistently. Also, I only really noticed the problem after I split the database. But it is a problem I have encountered before.
The database is saved as an Access 2000 version.
If anyone could help me solve this, it would be much appreciated!!!
In the form header there are some controls for the user to add new data. Usually this opens a pop up form, where the user will add the new data then I updates the underlying tables using code.
When the pop up form closes, I use Forms!Form.Requery to requery the main form so the new data shows in the main form detail.
The problem is doesn't! The user has to wait until he adds more data, when the previous data will then show or I put in a manual button for the user to reqery the form.
I've been trying to resolve this for a while bit not found a solution that works consistently. Also, I only really noticed the problem after I split the database. But it is a problem I have encountered before.
The database is saved as an Access 2000 version.
If anyone could help me solve this, it would be much appreciated!!!