popup form fails to update underlying form

O

ortaias

I have a datasheet form which allows you to select a specific record
for editing. Through the "edit" form, a popup form can be called to
make changes to a "list of values". The problem is that one case
(case1), the popup form works exactly as expected, however in another
case (case2) it does not. So far I have been unable to discern what is
"different" between the two methods of calling up the popup form. The
only clue that I have is the error message in case2 that "another user
has made a change to the record and the changes can not be saved".
After accepting the error message, the popup form works as expected for
that record. If I move to the next record the error sequence starts
over. I have tried DoCmd.save just before calling up and closing the
Popup form, but that has not worked. Since I am the only one using the
database, I have not be able to figure out why I would be getting this
type of error message for only case2. Since the popup form works as
expected in case1, I am at a loss as to why it will not work in case2?
 
O

ortaias

So far I have traced the problem to an underlying query. For some
reason, if the query only shows a filterd set then the popup form
works. If the query shows all records, then the popup form fails.
 
O

ortaias

Further experimenting has revealed that the popup form works with
"pending" projects and fails with "completed" projects. However, I
have not programmed any "locks" that would prevent changes to a
"completed" project. Obviously there must be a "lock' somewhere.
 
O

ortaias

Solved. The problem was evidently caused by a macro that tried to
process two events at one time resulting in a "write" error.
 
Top