Newbie Form Assistance - Unable to Edit

[fmulvaney via AccessMonster.com]

I built a form the other day that has a single subform. I subsequently
created another table that I needed to pull in to the form associated with
the other tables already tied to the original form. I created a query to do
this. Everything seemed to work fine. I was able to add the new fields to my
existing form. I was able to edit those fields. I messed around with adding
a button that would add a date time stamp to a memo field. I also messed
around some with locking some fields so they could not be edited.

I shut down and restarted the database and now I can't edit any of the fields
in the main form. I double checked the fields are not locked. I deleted the
button I was working on. I think there is some VB code floating around
somewhere related to my button. I'm able to locate records. I'm able to
change fields on the sub form but not the main form. I can't find the query
I used to pull in the new table although the new table's data shows up in my
form just fine. I just can't edit that data.

When I click to open the form from the general view via the objects toolbar
as the form opens in the bottom left I see the words for a split second "the
recordset is not updateable"

Can anyone help me diagnose and fix the problem?

Thanks

 

[Guest]

It is not uncommon to see queries that provide the desired data but because
of the structure of the query, the records cannot be updated through the
query.

I would suggest that you do a search in the Access Help file for "recordset
not updatable"

You will find a subject "Data can't be updated"

There are several reasons listed.

--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com

 

[fmulvaney via AccessMonster.com]

I will search as you instructed. Just so we are clear, at the time when I
set up the fields before I was able to add change records. Something changed.


Thanks

It is not uncommon to see queries that provide the desired data but because
of the structure of the query, the records cannot be updated through the
query.

I would suggest that you do a search in the Access Help file for "recordset
not updatable"

You will find a subject "Data can't be updated"

There are several reasons listed.

I built a form the other day that has a single subform. I subsequently
created another table that I needed to pull in to the form associated with

[quoted text clipped - 19 lines]

Thanks

 

[Guest]

If you are unable to edit your data in your form and you are seeing the
mesage that you posted, it is pretty safe to assume that the problem is with
the query that is supplying the record source for your form.

One way you can validate this is to run the actual query and see if you can
edit the data from the query. If you can, then there is some other problem
with your form. On the other hand, if you cannot edit the data in the query,
then it stands to reason that you would also not be able to edit the data
when it is in your form.

As for your being able to edit at one point and then not at another, I'm
afraid that I do not have enough detail to know what could have change to
cause this.

--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com

I will search as you instructed. Just so we are clear, at the time when I
set up the fields before I was able to add change records. Something changed.


Thanks

It is not uncommon to see queries that provide the desired data but because
of the structure of the query, the records cannot be updated through the
query.

I would suggest that you do a search in the Access Help file for "recordset
not updatable"

You will find a subject "Data can't be updated"

There are several reasons listed.

I built a form the other day that has a single subform. I subsequently
created another table that I needed to pull in to the form associated with

[quoted text clipped - 19 lines]

Thanks

 

[fmulvaney via AccessMonster.com]

Thank you for your help Mr. B.

If you are unable to edit your data in your form and you are seeing the
mesage that you posted, it is pretty safe to assume that the problem is with
the query that is supplying the record source for your form.

One way you can validate this is to run the actual query and see if you can
edit the data from the query. If you can, then there is some other problem
with your form. On the other hand, if you cannot edit the data in the query,
then it stands to reason that you would also not be able to edit the data
when it is in your form.

As for your being able to edit at one point and then not at another, I'm
afraid that I do not have enough detail to know what could have change to
cause this.

I will search as you instructed. Just so we are clear, at the time when I
set up the fields before I was able to add change records. Something changed.

[quoted text clipped - 17 lines]

 

[Guest]

Your welcome. I just hope that it did help you.

Mr B
email if needed to:
draccess at askdoctoraccess dot com

Thank you for your help Mr. B.

If you are unable to edit your data in your form and you are seeing the
mesage that you posted, it is pretty safe to assume that the problem is with
the query that is supplying the record source for your form.

One way you can validate this is to run the actual query and see if you can
edit the data from the query. If you can, then there is some other problem
with your form. On the other hand, if you cannot edit the data in the query,
then it stands to reason that you would also not be able to edit the data
when it is in your form.

As for your being able to edit at one point and then not at another, I'm
afraid that I do not have enough detail to know what could have change to
cause this.

I will search as you instructed. Just so we are clear, at the time when I
set up the fields before I was able to add change records. Something changed.

[quoted text clipped - 17 lines]

Thanks