How to Requery subform ... Fully

[DOYLE60]

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 comboboxes 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

 

[Alex Dybenko]

Have you tried to Recalc it?

 

[DOYLE60]

The Recalc gets an error when I compile it. I'm putting this in the code:

InventoryDialogUnitsSub.Recalc

But am getting a "Method or data member not found" error. I'm having trouble
with some wizards not working since I switched to Access 2000. Maybe once I
get that solved, this Recalc will work?
It also doesn't recognize repaint or refresh.

Thanks,

Matt

 

[Alex Dybenko]

Actually recalc is a method of a form, so if InventoryDialogUnitsSub is a
subform control - then make it:

InventoryDialogUnitsSub.form.recalc

also yopu can reclalc main form
me.recalc

 

[DOYLE60]

At your suggestion, I tried to do a Recalc. But the bugger doesn't like it.
It doesn't recognize it and doesn't recognize Repaint and Refresh either. But I
just updated to Access 2000 and am having problems with some wizards. Perhaps,
after fixing this the Recalc will work? If probably not, please advise.

Thanks,

Matt

 

[Alex Dybenko]

Can you compile your project? is me.recalc does not work? try to make a new
form and try recalc there