Adding Data

A

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
 
A

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
 
J

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]
 
Top