How do I write to a DIFFERENT table than the Record Source table?

[kealaz]

How do I write the information in my form to a DIFFERENT table, other than
the Record Souce of that form and then delete the record in the first table?

I have a form with Record Source: tblPOTODO. In it, I make selections using
combo boxes. Once all of those selections are made, I need to write that
information to a DIFFERENT table: tblBUY... and delete that record from
tblPOTODO.

Do I use a command button? Do I need to write a macro? What is the code I
would need?

Please help! Thank you so much for any assistance you can provide with this.

 

[Jeff Boyce]

What you describe doing -- remove a record from one place and put it in a
new place -- sounds just like how you'd handle a change of state/status ...
if you were limited to working with a spreadsheet!

There's no need to 'move' the record. Another approach would be to add a
single field to the table to hold the status of the record.

When that information stops being a PO and starts being a BUY, just change
the status.

(this is, of course, a gross simplification. I don't have enough specific
information to offer specific suggestions).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[a a r o n . k e m p f]

SQL Statements (fired through VBA) or-- if you're smart-- you can move
to SQL Server.

with SQL Server, you can setup a trigger on a table, so that whenever
someone changes X in table1, it can also move this update to table2.

to me-- I think that this would fit your needs exactly

-Aaron

 

[Aaron Kempf knows nothing]

if you're smart-- you won't listen to me