Update all records in another table???

  • Thread starter Thread starter Rick's News
  • Start date Start date
R

Rick's News

I want to create a button that on click it writes to the tblappointments.
I want it to create a new record for every [SSN] that is in the tblTBase.

How do I do this?

Thanks in advance!!!

-Rick
 
Assuming the SSNs are unique in tblTBase, the simplest way is to execute an
SQL Insert:

Currentdb.Execute "INSERT INTO tblappointments " & _
"(SSN, <list other *required* fields here>) " & _
"SELECT SSN, <enter literals or function calls for other required fields
here> " & _
"FROM tblTBase", dbFailOnError

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top