Kevin,

Add a row in the state combo that syas "ALL". Then you set filter logic can just "set filter to" when the user picks all.


>In my dataenvironment, I have a table with all fifty state codes and other info not being used in the current form. I have this table linked with a relation to a state code in another table which have one to many number of records with different states. I have a combobox linked to the statecode table by rowsource with the rowsourcetype as fields. When I select the state I want in the dropdown, it shows only those in the second table which are in that state in my grid, beautiful. When I first enter the tab which contains the grid, it shows a blank value as the statecode and shows all records in the second table, beautiful. Once I pick a state in the dropdown and have limited it, how can I get it to return to it's loaded state of showing all records in the second table without exiting the form and coming back into it?