adding records in mulitiple table using VBA

[kes]

hi,

I have two tables :
Table 1: Mission_Id , Mission_Type, Customer_Name...
Table 2: Supporter_Name, Report_Date, Area, Unit, Issue_Type, Error_Status,Mission_Id

I have a form that the users enter data into and send a report each day.
I would like that in a click of a button all the data I entered the day before and that have ="Open" will be entered into the tables with today's date.

Is that possible?

 

[namliam]

Sounds like you want to run an append query to add all data from yesterday with todays date, yes possible and easy.

Currentdb.Execute "YourAppendQueryHere"
Will run the query for you.

 

[David R]

I guess the bigger question is where is the data coming from... you mentioned a form, are your users working in the same database? If so you can probably flip an 'approved' switch on their daily records, rather than having to import the thing once on their side and then append it.

 

[kes]

hi,
the data comes from a form and from previous data in the table.
not sure what do you mean by an approve switch?

 

[kes]

I did an append query as namliam suggested and then an update query to link it to the rest of the tables.
works! thanks!