Select query not allowing change

[mav51 via AccessMonster.com]

Hi there,

I have a form that is generated by a simple Select query showing all records
where the field 'booPass' is true. I would like users to have the option to
uncheck that field(via the form) at this point but am not sure how to proceed
as the checkbox on the form does not react to a click and I have made certain
that it is enabled and not locked.
Any suggestions are welcome

Thanks,
Michael

 

[Dale Fye]

Michael,

My first guess is that you have created a query that is not updateable. Try
running the query by itself. Then see if you can make changes to this
field. If not, consult the following website for an explaination of the
various causes of a non-updatable query.

http://allenbrowne.com/ser-61.html

Allen has a whole bunch of very helpful stuff on his web site.

HTH
Dale

 

[mav51 via AccessMonster.com]

The query when run by itself is updateable and I can make and save changes to
that same field.

Michael

Michael,

My first guess is that you have created a query that is not updateable. Try
running the query by itself. Then see if you can make changes to this
field. If not, consult the following website for an explaination of the
various causes of a non-updatable query.

http://allenbrowne.com/ser-61.html

Allen has a whole bunch of very helpful stuff on his web site.

HTH
Dale

Hi there,

[quoted text clipped - 11 lines]

Thanks,
Michael

 

[mav51 via AccessMonster.com]

Never mind, I made a stupid mistake and forgot that the 'Allow edits'
property on the form was unchecked.

Doh!
Michael

The query when run by itself is updateable and I can make and save changes to
that same field.

Michael

Michael,

[quoted text clipped - 15 lines]