Form won't allow data entry

Leesha
BronzeLounger
Posts: 1488
Joined: 05 Feb 2010, 22:25

Form won't allow data entry

Post by Leesha »

Hi and Happy Holidays!
I should be out Christmas shopping but want to get this stupid piece of work done. I've attached a form that for whatever reason will not allow me to make changes and I can't find why. :hairout: I'm sure its a no brrainer that I should be able to figure out but I can't find it. I'm almost dreading the answer :scratch: .
Thanks,
Leesha
You do not have the required permissions to view the files attached to this post.
Top
User avatar
HansV
Administrator
Posts: 78595
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Form won't allow data entry

Post by HansV »

The record source of the form is a Totals query. Totals queries are never updateable. You'll have to use a table or a non-totals query as record source.
Best wishes,
Hans
Top
Leesha
BronzeLounger
Posts: 1488
Joined: 05 Feb 2010, 22:25

Re: Form won't allow data entry

Post by Leesha »

Thanks Hans! I don't feel quite so dumb. I didn't know that, although I will admit I forgot it was on totals so I was so frustrated, so I didn't think to test it. Another learning experience!
Thanks,
Leesha
Top

Return to “Access/SQL and other database applications”