J
Jayyde
Was that title complicated enough?
Basic scenario: I have a form
with assorted combo boxes, text boxes, and check boxes for the user to
select search criteria. I have a main form that opens off the main
filter that this creates, (a product master form if you will) then a
sub form on that with the specific products within that master. Kind
of like Blue shirts -> v-neck, crew-cut, etc (not exactly what I'm
doing, but the idea is similar). Now, I have the filter for the main
form working fine, now I'm trying to set up a filter for the subform.
Right now I can create the filter string and it's saved into a global
module, so I can pull it up in the main form just fine (into
strPFilter). I cannot for the life of me get it to actually filter
that sub form though. This is what I'm trying, which is obviously not
working:
frmProductChild.Application.DoCmd.ApplyFilter , strPFilter
Any help you Wizs out there can give me would be much appreciated =)
-Jayyde

with assorted combo boxes, text boxes, and check boxes for the user to
select search criteria. I have a main form that opens off the main
filter that this creates, (a product master form if you will) then a
sub form on that with the specific products within that master. Kind
of like Blue shirts -> v-neck, crew-cut, etc (not exactly what I'm
doing, but the idea is similar). Now, I have the filter for the main
form working fine, now I'm trying to set up a filter for the subform.
Right now I can create the filter string and it's saved into a global
module, so I can pull it up in the main form just fine (into
strPFilter). I cannot for the life of me get it to actually filter
that sub form though. This is what I'm trying, which is obviously not
working:
frmProductChild.Application.DoCmd.ApplyFilter , strPFilter
Any help you Wizs out there can give me would be much appreciated =)
-Jayyde