How to add values from form to another database

[tmb11152]

hi!!!

I will like to insert some values from a form in database1 to a table in database 2?
how should i do it?

query1 = "INSERT INTO "WHAT SHOULD I PUT HERE"(ID,COURSETITLE,VALIDDURATION,type) SELECT Text1,Text2,Combo1,combo2;"

I dont want to use link tables

thanks a lot​

 

[Trevor G]

Look to use an Append Query using the form objects as the criteria. No code needed.