I’ve just converted a number of Access97 databases to Access2003 databases and a strange thing happed when I try to us filter-by-form function in a SubForm (that is not linked to their main forms, there independent of each other). When I apply the toggle filter command or the apply filter/sort command the Filter-by-form,apply filter/sort,toggle Filter,and remove filter/sort command buttons gray out and can’t be used, no records are found and I can’t close the form! However I can use the binoculars “Find” function OK!
Prior to the conversions the filter-by-form functions worked OK!
Has anyone had this problem?
And if so can someone explain to me how to solve the problem?
Facts:
1)All the data for the SubForms come from a Table –> Query -> SubForm
2)All SubForms are inserted into main Forms that have NO query or table data dependencies.
3)All SubForms have their special Short-Cut menus.
4)All main forms have their own menus that also contain commands to find and sort records.
Prior to the conversions the filter-by-form functions worked OK!
Has anyone had this problem?
And if so can someone explain to me how to solve the problem?
Facts:
1)All the data for the SubForms come from a Table –> Query -> SubForm
2)All SubForms are inserted into main Forms that have NO query or table data dependencies.
3)All SubForms have their special Short-Cut menus.
4)All main forms have their own menus that also contain commands to find and sort records.
