popup form fails to update underlying form

  • Thread starter Thread starter ortaias
  • Start date Start date
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?
 
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.
 
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.
 
Solved. The problem was evidently caused by a macro that tried to
process two events at one time resulting in a "write" error.
 
Back
Top