Advertisement

07.22.2008 at 08:10AM PDT, ID: 23585385
[x]
Attachment Details

Refresh data in subform

Asked by PsychoDazey in Access Forms, SQL Query Syntax

I have a search form with a subform in MS Access 2005.  The subform is based on a pass-through query and is set to datasheet view.  On the main form I have a reset button that clears the fields on the main form and runs a query that returns 0 records on the subform.  The problem is 1) The subform does not refresh after running the pass-through query.  2) When I click reset then close and re-open the form, the subform does not display because there are no records...any thoughts?Start Free Trial
[+][-]07.22.2008 at 08:38AM PDT, ID: 22060545

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.

 
[+][-]07.22.2008 at 09:40AM PDT, ID: 22061172

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
[+][-]07.22.2008 at 09:51AM PDT, ID: 22061274

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.

 
[+][-]07.22.2008 at 10:11AM PDT, ID: 22061457

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
[+][-]07.22.2008 at 12:20PM PDT, ID: 22062688

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, SQL Query Syntax
Sign Up Now!
Solution Provided By: fhlio_admin
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.23.2008 at 07:28AM PDT, ID: 22069641

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
[+][-]07.23.2008 at 07:38AM PDT, ID: 22069771

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.

 
[+][-]07.23.2008 at 07:51AM PDT, ID: 22069929

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

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

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906