Good morning.
(I forgot to mention in thread title: This is Access 2007.)
Please bear with me as I explain the problem.
I have a table as the recorsource of a parent form. (tblBHA)
A subform is embedded in the parent form, as a continuous form. (subfrmSlide)
The data for the subform is a query, calculating some fields from about 3 other tables.
The subform is filtered to the [ID] field of the parent form's table.
My problem:
When I load the parent form, add a new record (via a different modal form), or refresh the information; The form seems to 're-iterate' the populating process about 4 times.
Currently, there are only 8 records that need displaying for my test.
The form takes about 3-4 seconds to load prior to becoming usable.
When I click on the form, or attempt to scroll, this is also painfully slow, as it seems to refresh the page whenever an action is performed with it.
The problem exists also when the subform is in DataSheet view, however not as severe.
What I have solved:
I don't believe it is a query issue.
The query isn't overly complex or big, and the query datasheet loads instantaneously.
Reducing the amount of fields on the SubForm doesn't improve the performance.
Another test, with only 2 records, loads the form in a fraction of the time.
Using some 'docmd.Echo' stuff in the refresh button and new record button code, eliminates a lot of the 're-iteration', but does not improve the performance of scrolling etc.
The query is not recalculated when scrolling or selecting textboxes etc, however, to scroll the form is unacceptably slow.
Cliffs:
- Parent form with embedded subform (continuous form).
- Embedded subform's data is a query. Data is filtered to Parent.
- Query is not complex, nor big.
- Subform is slow to 'paint'.
- Subform about to get it's head kicked in for ruining my morning.
Thank you for your patience, and any assistance you may offer.
Screenies:
(I forgot to mention in thread title: This is Access 2007.)
Please bear with me as I explain the problem.
I have a table as the recorsource of a parent form. (tblBHA)
A subform is embedded in the parent form, as a continuous form. (subfrmSlide)
The data for the subform is a query, calculating some fields from about 3 other tables.
The subform is filtered to the [ID] field of the parent form's table.
My problem:
When I load the parent form, add a new record (via a different modal form), or refresh the information; The form seems to 're-iterate' the populating process about 4 times.
Currently, there are only 8 records that need displaying for my test.
The form takes about 3-4 seconds to load prior to becoming usable.
When I click on the form, or attempt to scroll, this is also painfully slow, as it seems to refresh the page whenever an action is performed with it.
The problem exists also when the subform is in DataSheet view, however not as severe.
What I have solved:
I don't believe it is a query issue.
The query isn't overly complex or big, and the query datasheet loads instantaneously.
Reducing the amount of fields on the SubForm doesn't improve the performance.
Another test, with only 2 records, loads the form in a fraction of the time.
Using some 'docmd.Echo' stuff in the refresh button and new record button code, eliminates a lot of the 're-iteration', but does not improve the performance of scrolling etc.
The query is not recalculated when scrolling or selecting textboxes etc, however, to scroll the form is unacceptably slow.
Cliffs:
- Parent form with embedded subform (continuous form).
- Embedded subform's data is a query. Data is filtered to Parent.
- Query is not complex, nor big.
- Subform is slow to 'paint'.
- Subform about to get it's head kicked in for ruining my morning.
Thank you for your patience, and any assistance you may offer.
Screenies:
Last edited:
