I am able to add records to a single table just fine, I am able to edit records in 2 tables just fine, however, I am unable to add new records to 2 tables at once.I have two tables, table1 stores ...

You can add tabs to your form by using the Tab Control feature in Access. We show you how to create a Tabbed Form in Microsoft Access.

See the photo above to see the result. We hope this tutorial helps you understand how to sort and filter records in Access; if you have questions about the tutorial, let us know in the comments.