I have a main form with several sub forms. Currently, I can set the tab order to get from a field in the main form to a subform, but when I hit the tab key from the last field of the subform, the fields turn blank (I think it tries to insert another record in that form's table). Instead, I would like the tab key to send the cursor to the first field of the next subform, or at least to the main form without Access wanting to create a new record within the subform.
Do I need to insert a formula for that to happen?
Do I need to insert a formula for that to happen?
