I have a single table with 10 columns.
I have tried to create a main form with 3 combo boxes each containing values from 1 of the fields in the single table.
I have created a data sheet form of the single table with the 10 columns
I have created a subform with the source being the data sheet form.
I want when the user clicks the combo boxes that the subform below containing the table w/10 columns will filter/display based on combo box choices
I have done this successfully in the Client version (where I can use VBA) but I am now using the Web Access which is an entirely different animal. Please help. Been on this for two days
I have tried to create a main form with 3 combo boxes each containing values from 1 of the fields in the single table.
I have created a data sheet form of the single table with the 10 columns
I have created a subform with the source being the data sheet form.
I want when the user clicks the combo boxes that the subform below containing the table w/10 columns will filter/display based on combo box choices
I have done this successfully in the Client version (where I can use VBA) but I am now using the Web Access which is an entirely different animal. Please help. Been on this for two days