Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   A troublesome table (http://www.go4expert.com/forums/a-troublesome-table-t2644/)

toodlepip 22Jan2007 20:59

A troublesome table
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.

All times are GMT +5.5. The time now is 05:27.