D
DOYLE60
I'm having problems with these newsgroups. I have to send my posts several
times just for one to get through. I replied to those who have replied to this
topic quite a few times and the answers did not go through. This is my fourth
attempt, if it get though. (Any idea who I should contact? Thanks.)
Anyway, I tried the Recalc thing and it didn't work. But I updated to Access
2000 recently and am having trouble with some wizards. So once I fix my
Access, perhaps the Recalc will work.
The original question (saved on an email) was:
I have a subform that only partly requeries when I click a command button to
requery it. It only requeries the combo boxes, but not the list boxes.
The main form is unbound and contains the combo and list box filters. The
subform's control source, the query, filters the listboxes by drawing up the
queries the list boxes updates, and the combo boxes by an expression in the
criteria row.
I know that the query of the sub works and that both types of filters work for
two reasons. First, the report is based on the very same query and it filters
the combo and list boxes properly. Second, when I shuffle back and forth from
the form view to the design view and back to the form view again, the subform
is properly requeried, both combobox and list boxes.
The button on the form to requery the sub has code to update the listbox
queries followed by the requery action: Child83.Requery.
How do I supercharge this subform? How do I get it to fully requery? That it
only requeries partly seems impossible to me. I tried looking at repaint,
refresh, and all that, but no go.
Thanks,
Matt
times just for one to get through. I replied to those who have replied to this
topic quite a few times and the answers did not go through. This is my fourth
attempt, if it get though. (Any idea who I should contact? Thanks.)
Anyway, I tried the Recalc thing and it didn't work. But I updated to Access
2000 recently and am having trouble with some wizards. So once I fix my
Access, perhaps the Recalc will work.
The original question (saved on an email) was:
I have a subform that only partly requeries when I click a command button to
requery it. It only requeries the combo boxes, but not the list boxes.
The main form is unbound and contains the combo and list box filters. The
subform's control source, the query, filters the listboxes by drawing up the
queries the list boxes updates, and the combo boxes by an expression in the
criteria row.
I know that the query of the sub works and that both types of filters work for
two reasons. First, the report is based on the very same query and it filters
the combo and list boxes properly. Second, when I shuffle back and forth from
the form view to the design view and back to the form view again, the subform
is properly requeried, both combobox and list boxes.
The button on the form to requery the sub has code to update the listbox
queries followed by the requery action: Child83.Requery.
How do I supercharge this subform? How do I get it to fully requery? That it
only requeries partly seems impossible to me. I tried looking at repaint,
refresh, and all that, but no go.
Thanks,
Matt