Good morning.
I have a user form with about 50 fields. The data connections are several databases and submit through Outlook.
My problem is as follows:
When a person submits a form, the information writes to the database, but if someone types over the fields, it writes over that record. I have to open a new form which clears out the fields and moves the record pointer to a new record position (similar to the New Record command button).
There are situations where we need to reuse the (majority of the) information a user has entered, but when submitted it should be in a new record and not append the last record.
What I am looking to do is as follows:
When a user completes the form, and then clicks submit, a function is run to save the fields as global variables, the new record is initiated, the fields automatically get cleared out, and then another function is run to populate the fields with the old information.
I have created a couple of functions in JScript Function StoreFields( ) and Function PopulateFields( ), but I can't seem to find any code for New Record.
Any assistance would be greatly appreciated.
Thank you,
WHEELS