I am using a split form with the worksheet on the left and on the right is a regular form on the right with the regular form is a subform using the type of form of continuous form. I am trying to create a button that will automatically filter the sub form, which is a continuous form, with prespecified conditions. however it does not seem to work I have tried a couple of different options including DoCmd.pplyFilter As well as formname.filter with where conditions.
I just want to be able to click a button on the sub form and have it filter for my preset criteria.