JohnyG
09-18-2008, 01:00 AM
Hi
I have a user form which contains four fields. At the time of form initialization first two fields (Channel and State) got filled automatically. This is a sub form so the basis of the selection is depends upon the values (Channel and State) selected in master form.
My issue is I would like only those values in ?Product Number? combo box which was the outcome of the filter on sheet1 basis field (Channel and State).
For instance:
When I loaded this form and got the Channel as ?Store Purchase? and State as ?NC? then I only get Product # as ?122224532? and ?323333634?.
I also want when I click on close button this auto filter gets undone on the sheet. I have written the code in Change event of Combobox however it?s not working correctly?
I have a user form which contains four fields. At the time of form initialization first two fields (Channel and State) got filled automatically. This is a sub form so the basis of the selection is depends upon the values (Channel and State) selected in master form.
My issue is I would like only those values in ?Product Number? combo box which was the outcome of the filter on sheet1 basis field (Channel and State).
For instance:
When I loaded this form and got the Channel as ?Store Purchase? and State as ?NC? then I only get Product # as ?122224532? and ?323333634?.
I also want when I click on close button this auto filter gets undone on the sheet. I have written the code in Change event of Combobox however it?s not working correctly?