K
Kevin
I have a form whose record source is a temp table. When a
user needs to create a new record, the information is
inserted into the temp table, then when the information is
complete, a Save Record button is pressed, information
validated, a few calculations are performed and the
information is saved to the database, which resides in a
backend database on our network. If the user needs to edit
an existing record, the data is copied from the database
into the temp table and modified. Again, a Save Record
button is pressed, information validated, calculations
performed, and the information is agaiin saved to the
database. Until recently this all worked quite well. When
creating a new record, the temp table is recreated (Make
Table query) and then new information inserted into the
temp table. When editing an existing record, the existing
data is inserted into the temp table again using a Make
Table query. When I first set this up, as I recall, I was
having trouble running the Make Table query because of
record locking problems. To resolve this, before the Make
Table query runs, I inserted the following command:
Me.Recordsource="".
After the Make Table query is executed, I reestablished
the recordsource.
This resolved the Record Locking issue and allowed me to
proceed as desired. This worked fine until a few weeks
ago. I have started recieving an Error 28, Out Of Stack
Space error. I have stepped through the code and when it
happens, it always happens on this command. I do not have
any recursion, I have traced my code and stepped through
it enough to be confident of that!
Any suggestions? Anyone know why this might be happening.
THA!
Kevin
user needs to create a new record, the information is
inserted into the temp table, then when the information is
complete, a Save Record button is pressed, information
validated, a few calculations are performed and the
information is saved to the database, which resides in a
backend database on our network. If the user needs to edit
an existing record, the data is copied from the database
into the temp table and modified. Again, a Save Record
button is pressed, information validated, calculations
performed, and the information is agaiin saved to the
database. Until recently this all worked quite well. When
creating a new record, the temp table is recreated (Make
Table query) and then new information inserted into the
temp table. When editing an existing record, the existing
data is inserted into the temp table again using a Make
Table query. When I first set this up, as I recall, I was
having trouble running the Make Table query because of
record locking problems. To resolve this, before the Make
Table query runs, I inserted the following command:
Me.Recordsource="".
After the Make Table query is executed, I reestablished
the recordsource.
This resolved the Record Locking issue and allowed me to
proceed as desired. This worked fine until a few weeks
ago. I have started recieving an Error 28, Out Of Stack
Space error. I have stepped through the code and when it
happens, it always happens on this command. I do not have
any recursion, I have traced my code and stepped through
it enough to be confident of that!
Any suggestions? Anyone know why this might be happening.
THA!
Kevin