This is more of a general question (before I start trying to figure out how to do this in VBA) but do you have to actually "open" a table to add a new record or search the records it contains? For instance, if I have a form that is bound to one table and I want to create new records in *other* tables based on what the user enters into the form, do I have to actually open those tables (display them onscreen) or what? I'm working on an older Access application and I noticed that it does this: open table, add new record with appropriate data, close table. This seems silly to me.