Recordset error

[mdooley via AccessMonster.com]

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

 

[Irene]

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.

 

[mdooley via AccessMonster.com]

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,

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]

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
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,

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