Form from a Query but wont let me edit the results

[Hollypop]

Hello all, wondering if someone can shed some light on this for me.

I have made a query which looks up data from another tables, then from that query i have made a form.

So when i open the form it brings up all the entries like it should, however it will not let me edit the entrys.

for example on the screen shot below, the colums show the drop down boxes but it will not let me change what is currently in the box.

for ease i did a screen shot...(a picture says 1000 words!)

basically i need to be able to edit the entrys on this form, so that more than 1 record can be changed, in 1 screen. rather than having to individually go backthrough each record, on the main form.

if anyone needs any more info from me to help please let me know, i am sorry if i havent explained myself properly, i know what i want in my head, just hard to say in words!!

[MMcCarthy]

It means that your query is not updateable.

Check out this article on MSDN as it should help you to design an updateable query.

When can I update data from a query?

[Hollypop]

thanks, although i cant see no step by step guide or anything.

Im new to all this access stuff so just learning as i go

[MMcCarthy]

The link shows the type of queries you can have and still have the queries be updateable.

As a beginner you may also find it useful to check out the following article. Having the right structure to your tables makes all the difference when it comes to queries.

http://bytes.com/topic/access/insigh.../2#post2296372