Convert MDB to ADP problem

[Carmen]

Hello,

I would be grateful if anybody could help me solving the
problem of transfoming of my MDB database to ADP project.

To simplify the heart of the problem:

I have a table tblA with two fields Field1 and Field2 and
an another table tblB of the same structure. Then I have
an unbound form frm1. On this form I have a TextBox1 and a
command button. On click on the command button a parameter
append query is excuted where the parameter is the value
of the TextBox1.

The SQL form of this append query is:

INSERT INTO tblB ( Field1, Field2 )
SELECT tblA.Field1, tblA.Field2
FROM tblA
WHERE (((tblA.Field2)>[Forms]![frm1]![TextBox1]))

I would like to have a similar situation on may SQL
database. OK, I will displace the tables to SQL server but
how should I transform my parameter append query to wiev,
stored procedure or function (?) not to include to much of
VBA code but to keep as much as possible with the transact
SQL statements and using the same form?

I would be satisfied also with any hint or address where
to find the answer.

Best regards,

Karmen