I have a form that I'm trying to make universal so I don't have to keep redesigning it. Typically it shows the 7 days of a week for a series of events that take place every year. However the days change from year to year. If there is a missing field in the underlying the query, Access displays "Name" in the bound text box. I would like to trap this message and instead make the box invisible. Seems like I need some On Open code for the form but how do I intercept the error(s) that access detects? As there are presently 12 events and therefore 84 members of the grid, a bit of code shrinking might be useful too.
This is for aesthetics as well as letting the user focus on the only allowed days.