A troublesome table

Discussion in 'MS Access' started by toodlepip, Jan 22, 2007.

  1. toodlepip

    toodlepip New Member

    Joined:
    Jan 22, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I've got a form based on tblA left join tblB.

    tblB comes from a make table query.

    In my form, I can't edit the data in tblB. Which I would like to do. Any changes made in the table are reflected in the form, but I just can't edit in the form - no error messages or anything, just no response to my hitting keys!

    If I rename tblB, export it as .csv and reimport it back as tblB all works fine. If I then go back to the original version created by my query, it doesn't. This makes me suspect the table and not a setting on the form - willing to be proved wrong though.

    Any suggestions would be very very gratefully received.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice