Minor Problem!!!

  • Thread starter Thread starter Richard C
  • Start date Start date
R

Richard C

I had a query that had a yes no tick box on it!!! If it
wasnt clicked to yes, then the task was displayed to the
user. I used a simple after update Me.requery code, in
order that when a user clicked the tick box, it updated
the system and refreshed everything. The clicked task was
no longer displayed!!! The problem I have at the momment
is that when I click on the tick box, the machine beeps at
me and doesnt allow me to click the task and it wont
update!!!

I went to the query itself and it is locked there to, so
it is not a forms problem. Could I have Locked the query
or edited something to stop that from working. Other
queries are acting in a similar way, I have an over due
tasks querie, and when you click to complete the task that
beeps at me too, in the form and the basic query!!

Does anyone have any ideas?

Rich
 
Sounds as if your query has been changed in some way such that it's no
longer updatable. Thus, you cannot change the value of that field.
 
Well I just imported an older version of my query, it
worked perfectly in the older version of my database. Once
it was imported into my new database it no longer worked!!
The correct data was displayed to the screen, but it
wouldnt allow any changes to be made!! After your comment
I checked all the fields and they are all locked like the
yes no tick!!!

I tried creating a new one from scratch and that doesnt
work either!!!

Any Ideas?

Rich
 
Back
Top