By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Form from a Query but wont let me edit the results

P: 2
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!!
Dec 15 '08 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Dec 15 '08 #2

P: 2
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
Dec 15 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 15 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.