If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Select query not allowing change
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 |
#3
|
|||
|
|||
Select query not allowing change
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 |
#4
|
|||
|
|||
Select query not allowing change
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 |
Thread Tools | |
Display Modes | |
|
|