 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2008Recordset error
I created a form based on a query based on several tables. Wrong terminology I know but you get the idea. The form is of course to serve as a way to input data. It has been working as I have been creating the db until today when I tried to add some combo boxes and check boxes. Now I can't add a new record at all from the form view. At the bottom of the form the "new" button is grayed out and the "save and new" button at the top creates this popup: "You can not go to the specified record. You may be at the end of a recordset." In addition to that I can't modify the info within the form. I can't choose any option from the list boxes or type with in any text boxes. Does anyone know what I have done. I am clueless and very frustrated!! I am still new at this...obviously. Thanks, Melinda hi, in the form properties, u go to the all tab, the find the recordset type, u change it to "Dynaset (Inconsistent Updates)". then it should be can working. > I created a form based on a query based on several tables. Wrong terminology > I know but you get the idea. The form is of course to serve as a way to [quoted text clipped - 7 lines] > Does anyone know what I have done. I am clueless and very frustrated!! I am > still new at this...obviously. Thanks, Melinda Irene, I appreciate your help!! However, this didn't work...it did allow me to add a new record but then I couldn't view any of the previous record that were already in there. Another thing that is going on I can't change any info that is already in there or add anything new. For instance I can't even change an exisiting address - the cursor will show up in the block but then I can't type??? Any ideas? >hi, > [quoted text clipped - 6 lines] >> Does anyone know what I have done. I am clueless and very frustrated!! I am >> still new at this...obviously. Thanks, Melinda is it ur form is a single form? is it u mean that when u open the form, it was a new form, no record showing? actually from query datasheet there u can see the data, is it what u mean? if like this, u go to open your form, then go to properties, u find one call data entry, u see is it is set to no? if set to yes, then u change it to no for the data entry. then u try can or not? hope this can help u. > Irene, I appreciate your help!! However, this didn't work...it did allow me > to add a new record but then I couldn't view any of the previous record that [quoted text clipped - 13 lines] > >> Does anyone know what I have done. I am clueless and very frustrated!! I am > >> still new at this...obviously. Thanks, Melinda |
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.