form to table

  • Thread starter Thread starter Colleen
  • Start date Start date
C

Colleen

I want to know if there is an automated way to copy
information typed into one form "E-Actions" which belongs
to an E-Actions table to another formand table "E-Actions
History" and table name E-Actions History.

My main form is set up with tabs.

Thanks.
 
I want to know if there is an automated way to copy
information typed into one form "E-Actions" which belongs
to an E-Actions table to another formand table "E-Actions
History" and table name E-Actions History.

My main form is set up with tabs.

Thanks.
Click to expand...

The tabs are purely for appearance and have no effect whatsoever on
the data storage.

Why do you feel that you need to store the data redundantly? This is
*very* rarely a good idea!

If it is necessary in this case (and I agree it sometimes is), you'll
need some VBA code in the Form's AfterUpdate event to open a recordset
based on the E-Actions History table and append a record to it. Note
that you're not putting data onto the E-Actions History *FORM* - a
Form is just a window, and does not contain any data; you're putting
data into a Table (from which it may be displayed on a form if you so
desire).
 
To add more comments, you would also have to handle situation where the user
deletes records (if users are alowed to delete). This is just not an
effective way to handle history transactions.

Immanuel Sibero
 
-----Original Message-----
I want to know if there is an automated way to copy
information typed into one form "E-Actions" which belongs
to an E-Actions table to another formand table "E-Actions
History" and table name E-Actions History.

My main form is set up with tabs.

Thanks.
.
Click to expand...
Hi Colleen, have you considered using an append query?

Luck
Jonathan
 
No I haven't not sure what to do. Would it be a command
button that I would have on the page?
 
The reason I have done it this way is... I just couldn't
figure out an easy way of showing the most current record
for an employee. I am still not sure if what I am doing
is really working or not. I hate the redundancy also we
just have so many quirks here that it is hard to figure
out how to do some of the things.
 
Back
Top