I have a tabbed form that has on the first tab unbound fields of similar name to the fields of the main database. The main database is viewed on the second tab. Fields are named (as an example) Nname on tab 1 and name on tab 2.
What I would like to do is have a new record added to the main database based on the info of the unbound tab 1 data. Nname becomes name in the new record, Nphone becomes phone, etc. There is a command button ready and waiting on tab 1 to do this mighty task.
Tonight I am having a total mental blank as to the simplest way to accomplish this. Can anyone throw me a hint please?
Regards Brett
