K
Kevin
I have a form which is bound to a temporary table. If the
user is attempting to retrieve an existing record, several
queries are run which assemble the data into the temporary
table and the exsiting data is marked as being edited in
the database. If another user attempts to edit the same
record, they are prevented because it is marked. When the
user completes edtiting the record, it is saved back to
the database and unmarked. To clear the contents of the
temp table, I temporarily remove the recordsource, then
run a delete query whcih deletes data out of the temp
table. After any existing data is cleared from the temp
table, the table is repopulated with the data for the
chosen, pre-existing record.
The error I am getting occurs only upon first entering the
form. If I am useing a .mde, the application crashes. If I
am in a .mdb file, the VBA debugger drops me into a code
page and the troublesome line of code seems to be
Me!RecordSource = "".
What I find particullarly troubleing is that I do
something similar to this in several forms and have had no
trouble there. Someone suggested that this may be due to
inadvertant recursion. That is not the case. I traced the
code step by step until the error occurs and there is no
such problem.
Any help or ideas would be greatly appreciated!
Kevin
user is attempting to retrieve an existing record, several
queries are run which assemble the data into the temporary
table and the exsiting data is marked as being edited in
the database. If another user attempts to edit the same
record, they are prevented because it is marked. When the
user completes edtiting the record, it is saved back to
the database and unmarked. To clear the contents of the
temp table, I temporarily remove the recordsource, then
run a delete query whcih deletes data out of the temp
table. After any existing data is cleared from the temp
table, the table is repopulated with the data for the
chosen, pre-existing record.
The error I am getting occurs only upon first entering the
form. If I am useing a .mde, the application crashes. If I
am in a .mdb file, the VBA debugger drops me into a code
page and the troublesome line of code seems to be
Me!RecordSource = "".
What I find particullarly troubleing is that I do
something similar to this in several forms and have had no
trouble there. Someone suggested that this may be due to
inadvertant recursion. That is not the case. I traced the
code step by step until the error occurs and there is no
such problem.
Any help or ideas would be greatly appreciated!
Kevin