I have two tables I want to update...One table is a lookup table (Dates) and the other holds most of the information (History). I then have a query that finds the information i need that will be appended to both tables. One field in the query needs to update the dates in the lookup table "dates" and then the history need to get all related info.

Example:

Before Query -
(In Date Table) (In history table)
1/2/06 Jane Doe $10
1/3/06 John Doe $40

After Query -
(In Date Table) (In history table)
1/2/06 Jane Doe $10
1/3/06 John Doe $40
1/4/06 Jeff Doe $50 <---- How do I add this info, to both tables

What you need to do is have two append qry then use the button wizard and assing one of the append qry -
go into the coding behind the button
and look at the code add another line of code for the other qry

Thank you...works!