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.