Hiding a Record based on a drop down menu entry
I have a dorp down box in my database that is either set to Open or closed.
At the minute when closed is set the record is still visable, is there a way of hiding that record when closed is selected?
Also, is there a way of having it to automatically set to Open when a new record is created as at the minute I have to choose open on each new record I create
Thanks a lot