If I add a new record to a form, shouldn't all tables and queries update as well??
If I add a new record to a form, shouldn't all tables and queries update as well??
it depends upon what is he recordSource of you form. Check record source of you form make sure it is set to the table that you want to update. you say all Tables now by that if you mean all the tables in the database then no. The Form if it is a Bound form i.e. if it is linked to a table will update only that table and not any other table. if you can be a little clear it will be more helpful.