hi,
i am working on a project in access which has several tables and all this tables have a common field called village name. there are about five forms which are fiileed sequentially to fill up the table. what i need now is to be able to fill up the table and then save the data under a new name from any of the forms. i tried using clone recordsets but it does not work. i cloned a recordset but but could not save it using a different name. can anyone help?