listbox from query #2

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

Hello all!
(This was posted earlier but the replies were getting deep)

I have three nested forms (say, the parent, child, and
grandchild) I have a list box in the grandchild form, and
it should be populated based on a value in the child form.

I have query which can generate the needed values, and in
the criteria, I have [forms]![parent_form]![child_form]!
[control]

The query is functional. And will work without a prompt
when I open the form. However, when I change values in
the child_form, the query does not update the values in
the grandchild_form. (It just keeps the value the form
opened with)

How do I tell the form to redo the query each time the
values in the parent form are changed?

The help is appreciated! Thanks for the time.
Andrew
 
Have you tried:
[forms]![parent_form]![child_form]![grandchild_form].requery
or
[forms]![parent_form]![child_form]![grandchild_form]![control].requery
?
Depending on how you set up the grandchild form, these *should* work.

Good luck,
Alden

Note: Please respond to the group and not to my email address, as it isn't
checked and is used only to collect unsolicited emails.

andrew said:
Hello all!
(This was posted earlier but the replies were getting deep)

I have three nested forms (say, the parent, child, and
grandchild) I have a list box in the grandchild form, and
it should be populated based on a value in the child form.

I have query which can generate the needed values, and in
the criteria, I have [forms]![parent_form]![child_form]!
[control]

The query is functional. And will work without a prompt
when I open the form. However, when I change values in
the child_form, the query does not update the values in
the grandchild_form. (It just keeps the value the form
opened with)

How do I tell the form to redo the query each time the
values in the parent form are changed?

The help is appreciated! Thanks for the time.
Andrew
Click to expand...
 
Back
Top