realtime form update

  • Thread starter Thread starter CJay
  • Start date Start date
C

CJay

I have a table with a list of tasks including one yes/no field named 'done'.

I have a query that filters the tasks for not done.

I have a form in datasheet view listing all the tasks that are not yet done.

I would like to on ticking the done box for a record have that line
disappear leaving the remaing undone tasks.

Any ideas welcome.

Thanks
CJ
 
That sounds like the right idea from my way of thinking.
but I now get the error
Microsoft Access can't find the macro me.
 
Thank you very much that was exactly what I needed

tkelley via AccessMonster.com said:
I don't use datasheet views, so I can't say for sure it has anything to do
with that.

You could try converting it to a form view with continuous records. Then you
could put in a header with a refresh button with the requery code.

Then on the after_update of your checkbox, you could set focus to that button,
then run the button code.

Public Sub button_click
me.requery
End Sub

Public Sub checkbox_AfterUpdate
me.button.setfocus
call button_click
End Sub
That sounds like the right idea from my way of thinking.
but I now get the error
Microsoft Access can't find the macro me.
In the after update event of your checkbox, try this:
[quoted text clipped - 13 lines]
Thanks
CJ
 
Back
Top