I have a filter called TM_Flag. The flag value is set to equal 1.
I have a tab call TM. I am trying to determine how to limit all records to those that have the flag value of 1
If I limit in the tab itself i want to confirm the following steps
Right click on TM Tab
Sheet properties
triggers
on activate sheet, select in field and type in my filter named flag and assign the value of 1
Must I repeat this on the on exit sheet button??
If I want to limit the records at the table box sheet itself located inside the TM tab, would I accomplish this in the calculated box in the General tab or somewhere else?