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