Adding Data

[Asif]

I have a form which picks up data from the many side of a
relationship, when I go to add new data within this form I get an
error message saying data does not exisit in the one side of the
relationship. How do I go about adding this data in the one side when
I do a new entry on my form?

Thanks

 

[Asif]

I forgot to mention the record source of the form is a sql statment ,
which if i run this sql before inputting new data then I don't get the
error message as mentioned before.

Regards

 

[John W. Vinson]

I forgot to mention the record source of the form is a sql statment ,
which if i run this sql before inputting new data then I don't get the
error message as mentioned before.

Regards

Care to post the SQL statement, and the Recordsource properties of the form
and the subform?

We cannot suggest how to fix a problem when we cannot see the problem.

John W. Vinson [MVP]