Updating a Form with a Subform

[Guest]

Hello all,
I have a form whose record source is a query. The query ("qryAdoption") is
comprised of 3 tables: Adoption,Person,Pets. When I am creating a new
record, a subform is the third control in the tab order. This subform is
based on another table keeping track of the Adoption 'status'.
As I fill out my form, as soon as I enter the subform, the main form must be
trying to do a 'Save' and I get an error because the *Person* and *Pet*
information have not been selected yet.
Is there a way to stop this premature Save or otherwise supress the error
message?? Or how would any of you reccommend I fix this problem? I there
something I can change in the field at the table level??
I appreciate any advice you may be able to give me.
Thanks

 

[Guest]

I have found that if I change the table joins to OUTER joins, it works as it
should and I get no error.
Cheers!