Saving records in a temp table

  • Thread starter Thread starter Hans K.
  • Start date Start date
H

Hans K.

Hallo,
I'm pulling with FormA a record from TableA. Once I modify it, I would like,
via controlX, store the same information into TableB (tblTmp). However,
before storing I would like controlX to clear the content of TableB ( I
guess by adding NULLs).
Can it be done and if so, how?
Thank you much.
Hans.
 
-----Original Message-----
Hallo,
I'm pulling with FormA a record from TableA. Once I modify it, I would like,
via controlX, store the same information into TableB (tblTmp). However,
before storing I would like controlX to clear the content of TableB ( I
guess by adding NULLs).
Can it be done and if so, how?
Thank you much.
Hans.


.
create a query to delete the records from tableB then
Click to expand...
create a query to append from tableA to tableB
create a macro
line 1 setwarnings No
line 2 delete query
line 3 append query
line 4 setwarnings Yes
 
Ok Larry, I got it to work but only if I put some in the qry criteria field.
My tables are from SQL2k and I'm using views. How do I specify in a view
the recordID I have in a open form?
Thanks for helping.
H.
 
Back
Top