R
Rosalie
I installed Access 2007 on top of 2003 last weekend. I used it with one
database, in a data entry form with a subform, with no problems. But I have
another more important database, and when I try to update a record in the
data entry form (also with a subform), I'm not allowed to leave the record.
If I close the form, it says, "You can't save this record at this time.
XXXdatabase may have encountered an error while trying to save a record. If
you close this object now, the data changes you made will be lost."
I thought it might be because of the macro where the LastUpdate field is
set, and, sure enough, I had an error there in that I hadn't fully identified
the field; I fixed that error, and the field appears to update when I attempt
to leave the record, but I still can't leave the record and I lose my changes.
Any suggestions?
database, in a data entry form with a subform, with no problems. But I have
another more important database, and when I try to update a record in the
data entry form (also with a subform), I'm not allowed to leave the record.
If I close the form, it says, "You can't save this record at this time.
XXXdatabase may have encountered an error while trying to save a record. If
you close this object now, the data changes you made will be lost."
I thought it might be because of the macro where the LastUpdate field is
set, and, sure enough, I had an error there in that I hadn't fully identified
the field; I fixed that error, and the field appears to update when I attempt
to leave the record, but I still can't leave the record and I lose my changes.
Any suggestions?