 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / August 2005continuous form add record
I cannot get my form to allow the user to add q new record. This is a continuous form. I have set the allow additions to yes, but still not able to add a record? if I set Data Entry to yes I get now records. What setting am I missing > I cannot get my form to allow the user to add q new record. > This is a continuous form. > I have set the allow additions to yes, but still not able to add a > record? > if I set Data Entry to yes I get now records. > What setting am I missing Probably the query on which the form is based is not updatable. Most simple queries involving one or two tables are updatable, but more complex queries may not be. See the help topic, "When can I update data from a query?"  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) I am pulling the data straight from the table with no filters. > > I cannot get my form to allow the user to add q new record. > > This is a continuous form. [quoted text clipped - 7 lines] > complex queries may not be. See the help topic, "When can I update data > from a query?" > I am pulling the data straight from the table with no filters. > [quoted text clipped - 9 lines] >> complex queries may not be. See the help topic, "When can I update >> data from a query?" Hmm. Is your database open in read-only mode? If you open the table directly as a datasheet, can you edit it? Is this a local table in your .mdb file, or is it a linked table? Is user-level security in effect, such that you might not have permission to update this table? SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Dirk, Thank you for your time on this. I found my problem. I had to add the field that autonumbers to be able to update the form. > > I cannot get my form to allow the user to add q new record. > > This is a continuous form. [quoted text clipped - 7 lines] > complex queries may not be. See the help topic, "When can I update data > from a query?" |
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.