title: MS Access VBA hide or delete row from form but not table
body: <p>I use a form to edit a table. What I want to do is once a checkbox in the form is ticked or a field is filled out with some text I want to hide / remove this row from the form view but not delete the row from the table itself. Is this possible with VBA?</p>