Hi, I have a 3 column combo box on a form containing about 8 rows in this format:
1;Filter Opt1; control name of form object containing filter text (eg: me.txtFilt1)
So if the user selects "Filter Opt1" I want to use the contents of the specified filter (eg: contents of me.txtFilt1) as the filter string. So if the contents of me.txtFilt1 were: ="[Status]= ""Conf"" or [Status]=""Prov"" or [Status]=""Canx""" - then I want to be able to set a form filter to that criteria
I can get the field name from combo_box.column(2), in this case "me.txtFilt1", but how do I then get to the contents of the specified control name ?