Solved: Form now readonly

[f9073341]

The datasource of my form in Access is a 'JOIN' query so that I can retrieve data into the form from two different tables. Unfortunately, this has made the form read only!

Any suggestions to fix this? Or can you just not use a join query as a data source for access forms?

Many Thanks

[f9073341]

It's ok... I worked it out. I made the basic error of not having one of the keys which were joined as a primary key.

If you don't have one of the joining fields as a primary key, the fields within the form you're using will be read only.

Cheers.