locked
error 3332 RRS feed

  • Question

  • what causes the following error: "Cannot enter value into blank field on 'one' side of outer join. (Error 3332)"
    Monday, February 29, 2016 6:41 PM

All replies

  • 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

    Monday, February 29, 2016 8:20 PM
  • 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

    Tuesday, March 1, 2016 5:52 AM
  • 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.


    Tuesday, March 15, 2016 11:29 AM