refreshing subforms

[Mark Elliott]

I don't think I explained my problem enough. First you
select an option from the combo box. Then a filter is
applied and the checkboxs will show what the tests the
selection passed. Now based on those checkboxes, I have a
VBA program create a temporary query. This temporary query
is the basis for the subform and is what searchs the data
the subform is based off of. Now all of that works fine,
however the subform will not reflect the changes if I
select a new option from the combo box. So my question is
based off of this how do I get the subform to refresh the
data when I select a new option as that is the only thing
not working. I hope I did a better job explaining. Oh
and I am using access 97 and it refreshes correctly if I
go to design view and then back to form view. Somebody
please help me. Thanks

PS. I reposted this so that hopefully more people will
see and help me out here. Thanks

 

[Paul Finey]

Hi Mark
After your VBA code that generates your query try,

Me![Formname]![SubformObjectName].Requery


HTH

Paul

 

[Jonathan]

-----Original Message-----
I don't think I explained my problem enough. First you
select an option from the combo box. Then a filter is
applied and the checkboxs will show what the tests the
selection passed. Now based on those checkboxes, I have a
VBA program create a temporary query. This temporary query
is the basis for the subform and is what searchs the data
the subform is based off of. Now all of that works fine,
however the subform will not reflect the changes if I
select a new option from the combo box. So my question is
based off of this how do I get the subform to refresh the
data when I select a new option as that is the only thing
not working. I hope I did a better job explaining. Oh
and I am using access 97 and it refreshes correctly if I
go to design view and then back to form view. Somebody
please help me. Thanks

PS. I reposted this so that hopefully more people will
see and help me out here. Thanks
.

Hi Mark,

In the combobox_AfterUpdate() event have you tried to
requery the subform?

Luck
Jonathan