J
JFrank Brock
...(Not sure this actually posted earlier... Had trouble w/ my
reader. sorry if duplicated)
The goofy problem is when I am doing a record add on the main form or
when I update the main record.
During add, while I enter data in the field and then tab to the next
field on the main form, I get a second or two delay while the status
bar shows "Calculating." and then I can move on.
During an update, after I make a change to a field in the main form
and then tab to the next field, I get the same delay and
"Calculating." message. If I make no change to the field and just tab
from field to field, I do not get this delay or status bar message.
I have a main form with 2 sub forms. Each form (main and sub forms)
are on a separate page of a tab control. They seem to be properly
linked with indexes on the sub form tables for the linked fields.
Both sub forms are linked to the main form by one field. Sub form 1
is based on a table. Sub form 2 is based on a view. Each sub form is
on a separate tab control page from the main form (total of 3 tab
pages).
I do not have any calculated fields or any domain aggregate functions
used in the forms. I do have several combo boxes on the main and one
on the sub forms.
The database is located on an SQL2K server. Watching the SQL
profiler, I can see that the form seems to be doing a requery of the
sub form data during these recalc's and trying to repopulate the sub
form recordsets every time a main form field is made dirty. I might
expect this requery after the changes are saved for the main record
but not during the record edit.
Any ideas why this is and how to stop it?
Thanks
Frank Broc
reader. sorry if duplicated)
The goofy problem is when I am doing a record add on the main form or
when I update the main record.
During add, while I enter data in the field and then tab to the next
field on the main form, I get a second or two delay while the status
bar shows "Calculating." and then I can move on.
During an update, after I make a change to a field in the main form
and then tab to the next field, I get the same delay and
"Calculating." message. If I make no change to the field and just tab
from field to field, I do not get this delay or status bar message.
I have a main form with 2 sub forms. Each form (main and sub forms)
are on a separate page of a tab control. They seem to be properly
linked with indexes on the sub form tables for the linked fields.
Both sub forms are linked to the main form by one field. Sub form 1
is based on a table. Sub form 2 is based on a view. Each sub form is
on a separate tab control page from the main form (total of 3 tab
pages).
I do not have any calculated fields or any domain aggregate functions
used in the forms. I do have several combo boxes on the main and one
on the sub forms.
The database is located on an SQL2K server. Watching the SQL
profiler, I can see that the form seems to be doing a requery of the
sub form data during these recalc's and trying to repopulate the sub
form recordsets every time a main form field is made dirty. I might
expect this requery after the changes are saved for the main record
but not during the record edit.
Any ideas why this is and how to stop it?
Thanks
Frank Broc