Access form Refresh

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

Guest

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!
 
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
 
You must log in or register to reply here.

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

Access Form Refresh 1
subform will not refresh 6
subform-on Main form not refreshing queried job list 2
Refreshing Data Form in a Tab 1
Query Parameter using multiple options 0
Refresh Table 3
Access Sub form opens before the main form in MS Access 0
form still on task bar 1

Back
Top