Hi All,
I have a form displaying information from 2 tables and a few custom fields that are acting as keys for unique record identification. I know I shouldn't do this but I want to write the information shown in the current form to a new table I have designed as a log of this record being generated. The form has been designed to only show the active dataset so there will be no other data to worry about.
How do I code a button to transfer the currenly displayed data on the form into my new table???
Can anyone help me???
Tony
I have a form displaying information from 2 tables and a few custom fields that are acting as keys for unique record identification. I know I shouldn't do this but I want to write the information shown in the current form to a new table I have designed as a log of this record being generated. The form has been designed to only show the active dataset so there will be no other data to worry about.
How do I code a button to transfer the currenly displayed data on the form into my new table???
Can anyone help me???
Tony