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