Refreshing issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a continuous subform, and on it there are two rows of check boxes. I
have a command button on it that, when clicked, matches the bottom row of
check boxes to the top row. My problem is, whenever the button is clicked,
the checks don't appear on the bottom row. Looking at the table, the values
were changed, and when I click on one of the bottom row boxes that is
supposed to be checked, a check quickly appears and then disappears. To try
to fix this, I added DoCmd.Requery to the command button, and this makes the
checks appear properly. The problem here, however, is that when the requery
is done, it scrolls me all the way back to the top of the continuous subform!

So I guess I either need a way to make the checks appear without requerying,
or a way to requery that doesn't kick me back up to the top of the subforms...

Thanks,
Tim
 
You could try using me.refresh

(in the after update event of the button code, or the check box
itself...depending on how/where you do this).
 
Hi,
I have placed me.refresh in after update property of check box. This
checkbox is located in the form, linked to query. Checking the box should
filter out record, and hopefully make it disappear. For some reason it does
not happen. This form is displayed as Datasheet
 
Back
Top