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
Click to expand...

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