Why error if data is saving correctly

P

Pete Merenda

This is a duplicate with one change, my relationship is one to one... Help
would be very appreciated.

I have a form(2) that loads from another form(1), each of which is bound to
seperate tables, with a one to many relationship defined (1-2). When I open
Form 2, I save the record in 1 and close that form. (Data saves properly to
table 1). When I close form 2, I get a "Access may have encountered an error
while saving....you will lose your changes."

Oddly, all the data saves properly from form 2 to table 2 despite the
message. Since there's no "Help" attached to the error, I can't figure out
why it's happening.

I could probably disable the error so users aren't confused, but I obviously
want to understand the source of the problem.

Any suggestions???
 
Top