J
Jim
Yes, the references are ok... I figured out what exactly
is causing the problem, however I have no idea how to fix
it.
The problem happens when I have a subform with a Record
Source that consists of a temp table with an inner join on
another table with pre-existing data.
I then have code on the parent form that creates a record
in the temp table. Despite the fact that I requery the
form, the record Source of the form becomes invalid and
causes all sorts of havock.
My best guess is that it is a timing issue in access...
Does anyone have any other ideas or suggestions on how to
get by this? The problem just came up in an entirely
different section of the program and is happening in the
2000 version.
Sigh
-Jim
is causing the problem, however I have no idea how to fix
it.
The problem happens when I have a subform with a Record
Source that consists of a temp table with an inner join on
another table with pre-existing data.
I then have code on the parent form that creates a record
in the temp table. Despite the fact that I requery the
form, the record Source of the form becomes invalid and
causes all sorts of havock.
My best guess is that it is a timing issue in access...
Does anyone have any other ideas or suggestions on how to
get by this? The problem just came up in an entirely
different section of the program and is happening in the
2000 version.
Sigh
-Jim