Hi I'm working with a main form and subform with 3 combo boxes that control the records and vba to control record sources.
If the combo boxes select a combonation of criteria for record does not exist in the query. I get error 2455 see image below. I can bypass this warning with error handling, but then the form goes blank (see image below). I would like the choices to remain visible and the records blank (if someone was changing a combo box, but wasnt finished selecting all criteria), and possibly a msgbox to say that record does not exist, make a new selection.
The main problem is after an error, the form goes blank. Please resolve?
images linked here: excelforum.com/access-tables-and-databases/897459-access-vba-forms-error-2455-then-invisible.html?p=3112931
