Yes/No disabled

R

Ray

I built a form with several sub forms a few weeks ago and everything worked
fine. I had a request to change some data today and I am now unable to check
or uncheck my Yes/No field.

I have made sure that the field is Enabled and that it is not Locked.

I put in code to change the value when either clicked or afterupdate and
neither set was executed when I clicked on it (I had a "stop" on in the
debugger).

The only change I have made to the database since it last worked is that I
changed the key fields from autonum to text type.

I do have buttons on the page that use queries to reset all the values
either On or Off and they still work.

Anyone have any ideas on something else to check on or how I should proceed?
 
R

Ray

I put a couple more watches on to see if I could figure out anything else.
The "Enter" event showed that I could not update the element because "the
recordset is not updateable". When I followed the Help on that, it says that
it is "bound to a snapshot-type result set object" and adds that snapshot
fields in Jet cannot be edited.

Any ideas how I got to be a snapshot and how to get it not to be a snapshot
again?

Thanks,

Ray
 
R

Rick Brandt

Ray said:
I put a couple more watches on to see if I could figure out anything
else. The "Enter" event showed that I could not update the element
because "the recordset is not updateable". When I followed the Help
on that, it says that it is "bound to a snapshot-type result set
object" and adds that snapshot fields in Jet cannot be edited.

Any ideas how I got to be a snapshot and how to get it not to be a
snapshot again?
Click to expand...

That is just the help file suggesting one possible reason. Most queries are
not editable. Examine the query being used by the form to see if you can
edit data directly in its datasheet. If you cannot then you need to see if
the query can be re-designed so that it is editable. There is an entire
help topic that talks about the ability to edit data in queries.
 
R

Ray

Rick,

Thanks for the quick reply. I did a search on that subject and found that I
was not able to update based on using Grouping in my underlying query. I
removed the grouping and was able to check uncheck in datasheet view. I'm
assuming that will translate to update capability in form view also.

Ray
 
Top