error 3332

Question

what causes the following error: "Cannot enter value into blank field on 'one' side of outer join. (Error 3332)"

Answer 1

Can you please give us some details? It sounds like you have a query with two tables and you are trying to enter a record on the child side before entering a parent record, but we will need more information to help you.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 2

Hi, dapinkerton

You only provide a error message and you want to get solution regarding your issue. Many reasons are there to occur this error. So we need to confirm that which one is related to your issue. For that it is helpful if you provide table design and query to reproduce the issue.

Regards

Deepak

Answer 3

hi, dapinkerton

you should use Form to insert data and you can use query with an outer join to display the data. because there is always a chance of getting error when we try to insert data using query with joins. so it is better that we can use form so that chances are less to get error.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.