sending info to tables....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to send the information from a form to 2 separate (but with
identical fields) tables?

I have a form where information from the current order is entered. This
form sends information to a table, which in turn sends that information to a
report. Each time the form is opened, the table is deleted, and then created
again to maintain that ONLY the most current record appears on the report.

However, I would like to have a table that stores all past orders as well,
so it does not get deleted each time. Basically I'm trying to figure out a
way to get the form to send its information to 2 separate, but identical
tables. Any suggestions?
 
When you close your form, run a query that dumps the current order into
your history table. Probably the easiest thing to do would be to
create an append query and then in the On Close property of the form,
run the query.
DoCmd.OpenQuery "MyQuery", where "MyQuery" is the name of your append
query.

Hope that helps!
 
Back
Top