Advertisement

07.22.2008 at 09:32AM PDT, ID: 23585657
[x]
Attachment Details

Keeping a list box in sync with its parent form

Asked by jondecker76 in Access Coding/Macros, Access Forms

Tags: Microsoft, Access, 2003

I can't seem to keep a list box synced with its parent form.

Here is the layout:
mainForm
     +subForm1
          +lstListbox

I have the child and master fields between mainForm and subForm1 linked, so that the subform updates along with its parent. But the lstListbox control has a query of its own that must be updated whenever subForm1 is updated. I have tried putting me.lstListbox.requery in the onCurrent event of subForm1, but this causes an endlsee cycle of "Calculating...." to appear in the status bar, and the lstListbox to be continually requeried even if nothing is happening. Because of this, if I select a control, it goes out of focus as fast as I can try to keep in selected.

How can I make lstListbox stay in sync with its parent form (which is a subForm)?


thanks
Start Free Trial
 
Keywords: Keeping a list box in sync with its pare…
Title
1 Sync Subform to Mainform when selec…
2 Run-time Error 2455 in Requery Co…
3 Syncronizing 2 subforms on unbound …
4 Sync multiple subforms
5 Requery in a subform
6 subform
 
Loading Advertisement...
 
[+][-]07.22.2008 at 09:35AM PDT, ID: 22061127

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:42AM PDT, ID: 22061187

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:10AM PDT, ID: 22061444

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 04:36AM PDT, ID: 22067962

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 04:40AM PDT, ID: 22067987

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 06:22AM PDT, ID: 22069010

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 Coding/Macros, Access Forms
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: boag2000
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.23.2008 at 08:33AM PDT, ID: 22070350

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.

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