Access form Refresh

J

James O

Hey All,

Quick question. Is it possible to refresh a form without closing it and
re-opening it? I have a form connected to a query there is a check box on the
form marked complete. The query says show records that dont have complete
checked. I have a button on the form that marks groups of accounts as
complete. So when they click the button I want the accounts to fall off the
form as they do if I close and re open it. Thanks!
 
D

Dirk Goldgar

James O said:
Hey All,

Quick question. Is it possible to refresh a form without closing it
and re-opening it? I have a form connected to a query there is a
check box on the form marked complete. The query says show records
that dont have complete checked. I have a button on the form that
marks groups of accounts as complete. So when they click the button I
want the accounts to fall off the form as they do if I close and re
open it. Thanks!
Click to expand...

This is not a Refresh operation, but a Requery opeartion. The line of
code you want (for a command button on the form) is

Me.Requery
 
Top