I am working with an existing database that has a "Current" field in some of its tables. The "Current" field is a Yes/No checkbox and its function is to make the pick list choice associated with it visible/invisible in the Access database form (see picture below).
I have created two new tables and I would like them to have the same structure as this one. However, when I create a Yes/No checkbox "Current" field it does not do anything. I have refreshed the table in the Access database and Refreshed All data and still nothing.
I have looked at the properties of the existing "Current" fields that do what I would like them to do and they are just simple Yes/No checkbox.
I have only worked with Access for 2 months and I am hoping one you gurus out there can help.