Select query not allowing change

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

--
Message posted via http://www.accessmonster.com

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" u40799@uwe wrote in message
news:8760dfd2ab926@uwe...
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

--
Message posted via http://www.accessmonster.com

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

Michael

Dale Fye wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200807/1

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

Doh!
Michael

mav51 wrote:
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]
Thanks,
Michael

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200807/1