Advertisement

05.04.2008 at 09:45AM PDT, ID: 23375017
[x]
Attachment Details

How do I refresh a form after an update query?

Asked by sebrame in Access Forms, Access Coding/Macros

Tags: Microsoft, Access, 2007

I have a split form (form at the top and datasheet subform below). I have a checkbox to mark which records to print. After printing I run an update query to clear the checkboxes. I can use a button to run 'me.refresh' to refresh the form so that the checkboxes show as cleared, but is there a way to incorporate the refresh of the form in the actual update query that clears the checkboxes?

Thanks,
SteveStart Free Trial
[+][-]05.04.2008 at 12:03PM PDT, ID: 21496621

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.04.2008 at 03:33PM PDT, ID: 21497196

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Forms, Access Coding/Macros
Tags: Microsoft, Access, 2007
Sign Up Now!
Solution Provided By: ldunscombe
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628