I have a main form built off of a query with 4 or 5 subforms, each built off seperate queries. I created the subforms as regular forms and dropped them on a tabs. The forms when i built them have macro requery on them that runs off a timer interval (every 2 minutes). When I run the main form and the timer on the subform goes off I get this message.
You can't use the ApplyFilter action on this window.
*You tried to use the ApplyFilter action or method, but didn't apply the filter to a table,query, form or report
*You may have applied the filter to a form, but the form wasn't open in Form or Datasheet view.
*You may have applied the filter to a report, but didn't use the ApplyFilter action in a macro specified by the OnOpen property setting.
Use the SelectObject action or method to select the table,query, form, or report before applying the filter.
Being fairly new to Access, and reading books and looking at the web I am stuck. Any help would be appreciated.
You can't use the ApplyFilter action on this window.
*You tried to use the ApplyFilter action or method, but didn't apply the filter to a table,query, form or report
*You may have applied the filter to a form, but the form wasn't open in Form or Datasheet view.
*You may have applied the filter to a report, but didn't use the ApplyFilter action in a macro specified by the OnOpen property setting.
Use the SelectObject action or method to select the table,query, form, or report before applying the filter.
Being fairly new to Access, and reading books and looking at the web I am stuck. Any help would be appreciated.
