Some general information about forms in Access may be helpful as you continue your development. There are times where it is necessary or useful to use an unbound form and to force the user to click a button to save a record. However most Access forms are bound to a data source, which can be either a table or query, and in those cases you don't need any code to save a record - moving away from the record currently being added or edited automatically saves the data on the form for you. That is very useful in cases where you are using sub-forms in Access. That is also generally unique to Access - the beauty of it is that it reduces the amount of code you are required to write, and in general makes applications less complex, and thus less bug-prone.

Wendell