1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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