Hello!
I created a form in which I placed a subform. Based on the selections made from a series of check boxes in the form a table is created and the data populates the subform. The problem I am having is that when the user clears the check boxes to enter a new combination of criteria, the table to the subform is locked. What is the code I need to use in order to close the subform's table so the table can actually be recreated? Is this possible?
Thanks so much!!!!
M
I created a form in which I placed a subform. Based on the selections made from a series of check boxes in the form a table is created and the data populates the subform. The problem I am having is that when the user clears the check boxes to enter a new combination of criteria, the table to the subform is locked. What is the code I need to use in order to close the subform's table so the table can actually be recreated? Is this possible?
Thanks so much!!!!
M
