 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / March 2006Form Problem
I recently built a database and have created a form for data review/entry pulling from a query. My problem is that I currently cannot change anything in any of the fields. I can tab through the fields, click into the fields, but cannot make any changes to them. The records are not locked. They are all enabled. Please help! Sorry, forgot to mention that I'm using 2003 Hi, Typically you can only change something in a form if the form has Edits, Delete and Additions set to yes - on the Form Properties. As well, if you have used the Totals (Greek Sigma) feature on a field in your query, you won't be able to change the data on the form. Also, depending on how you get to your form. If you are accessing it through a Switchboard, and the form is set to Add mode, you won't be able to edit your records. It sounds like there is a feature that has been disabled on your form that is preventing your ability to change your data. If you provide more information it might help solve your problem. Clare The totals issue was part of the problem for one form. Thanks! >I recently built a database and have created a form for data > review/entry pulling from a query. My problem is that I currently > cannot change anything in any of the fields. I can tab through the > fields, click into the fields, but cannot make any changes to them. > The records are not locked. They are all enabled. Please help! How many tables are in the Query? Are the primary key fields of the table you want to update included? (And, as has already been said, if it is a Totals Query, it will not be updateable.) Larry Linson Microsoft Access MVP I have three tables. None have a primary key because they are tables that are generated by queries through make-table queries and will be overwritten on a daily basis. Could this be part of the problem? (When I run the query, I cannot update any of the fields from the datasheet either.) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.