M
Melissa F
I have a question for the brillant minds of this group.
I have a database I would like to do a mass update on a table based on
information from another table.
Example:
TblEmployee (empID) (Last_Name), etc.
TblCerts (empID) (CertsID) (certName) (certDate) (MiscInf)
They are join by empID
I would like to do a mass update based on a variables
First: Select a company from a form with drop down box(variable company
would change each time) (Company in TblEmployee)
Second: Select the employees that need to be update (Yes/No box) (Datasheet
form view) (TblEmployee)
Third: Update certs ((variable) cert would be different each time) for all
employees selected previously (Certs to be updated are in TblCerts) Here's
another catch some employees will have the cert already so just need to
update date associated with that cert others would need the cert AND date
added.
I know it's alot to ask I have it all laid out in my head I just can't quite
get the code going. Thanks so much.
I have a database I would like to do a mass update on a table based on
information from another table.
Example:
TblEmployee (empID) (Last_Name), etc.
TblCerts (empID) (CertsID) (certName) (certDate) (MiscInf)
They are join by empID
I would like to do a mass update based on a variables
First: Select a company from a form with drop down box(variable company
would change each time) (Company in TblEmployee)
Second: Select the employees that need to be update (Yes/No box) (Datasheet
form view) (TblEmployee)
Third: Update certs ((variable) cert would be different each time) for all
employees selected previously (Certs to be updated are in TblCerts) Here's
another catch some employees will have the cert already so just need to
update date associated with that cert others would need the cert AND date
added.
I know it's alot to ask I have it all laid out in my head I just can't quite
get the code going. Thanks so much.