I have searched for a method of copying records.
Is there a way to enter all of a person's info once into a form and then create a macro to copy/save to/save as/duplicate the info into two or three tables?
I can only find the copy command for a whole object, such as a complete form, in the macro options. (I have a hard time wrapping my head around code, sorry!)
I don't suppose there is anyway a bound control can have two sources?
The data I need to enter requires two or three different name titles in two or three different tables, but all the other info of course is the same (e.g. place of birth, DOB, parents, age, etc.).
Lowell