Modify Table A with data from Table B

[Cryptographic_ICE]

Hello,

I have a table that contains the name and location of backup tapes.
The first Column has the tape ID (a four digit number) and the second
column has a drop down box of possible locations such as "In Drive" or
"In Storage". I also have a list of tape id's that were moved to
storage. (the list is currently an access table) I would like to
create a macro that would change the location column of the table to
"In Storage". How could I accomplish this? any help is appreciated.

[GH]

On Apr 18, 3:12 pm, [e-mail] wrote:

Hello,

I have a table that contains the name and location of backup tapes.
The first Column has the tape ID (a four digit number) and the second
column has a drop down box of possible locations such as "In Drive" or
"In Storage". I also have a list of tape id's that were moved to
storage. (the list is currently an access table) I would like to
create a macro that would change the location column of the table to
"In Storage". How could I accomplish this? any help is appreciated.

Is this a one-time update event, or do you need to perform this change
every time another tape is moved to storage? You can perform a one-
time update using an update query -- UPDATE tblTapeLocation SET
CurrentTapeLocation = "In Storage" WHERE TapeID IN (SELECT TapeID FROM
tblTapesInStorage) -- but this is not sufficient for ongoing
operations where you want to automate this behavior. If you are using
a form to identify tapes moved to storage, you can fire an event that
updates your other table when a tape is marked as moved, but you would
need to code the specific update to the record being moved. Also, if
you need these updates to occur when a tape is placed back in use,
that would require logic in the code that allows marking tapes as In
Drive again.

HTH
- GH