update query not quite working

B

Boysie

I am creating an exercise database for instructors to use. Pretty simple -
they select an exercise using a tick box from a continous form and it prints
the selected exercises in the report. I have tried creating an update query
to deselect all the boxes but for some reason when i run the query it only
deselects the boxes when I hover the mouse over the tick box or when i click
the mouse on the record line. Any ideas?????
 
C

Clifford Bass

Hi,

After you run the query you need to refresh or requery the form. Use
one of these, whichever works:

Me.Refresh
Me.Requery
DoCmd.Requery

Clifford Bass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top