What are the possible causes...Please??

P

Pete Merenda

I know this is a broad question, but can someone offer the potential causes..
No one has offered an answer as yet.

I have a form(2) that loads from another form(1), each of which is bound to
seperate tables, with a one to one relationship defined. 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've tried a huge number of modifications, to events and actions but can't
seem to locate the problem.

Any suggestions as to the cause of the error -- when everything seems to
querying and writing correctly???
 
B

BruceM

I believe the error is because you defined a relationship but do not have the
related table available (because form1 is closed). You could probably avoid
that by hiding form1 rather than closing it, then use the Close event of
form2 to close form1, or something like that. What is the purpose of the
one-to-one?
 
P

Pete Merenda

Thanks for your reply. I've changed actions for Form1 to close before and
after Form2. I've changed the one to one to a one to many, thereby adding a
new primary key to table 2. The subforms on Form 2 are synched and write
correctly, as does the primary form. There are no fields on any form that
require validation. I have no "odd" actions related to the form's unload or
close events. Everything works as intended, but I still get the "Access may
have encountered an error while saving..."

I'm totally perplexed. I'm sure I don't want to train users to ignore the
error message. Would you have an ideas for experiment at all?
 
Top