VB Question

I am wondering if it is possible to change the WHERE clause of this statement
to select the current record of a form.

Lets say on a search form a user searchs for a record, i would like them to
be able to press a button and have that record put into another table. I have
generated this code ( which is pretty much and append query) but im wondering
if how i can put this into VB code and how i can change the WHERE clause to
select the current record on a from.



INSERT INTO SRMisc ( [Tracker Item], Description, Comments, Requestor, [SR
Num] )
SELECT Tracker.X5, Tracker.Z1, Tracker.Z2, Tracker.Z3, Tracker.Z6
FROM Tracker
WHERE (((Tracker.Z6)="3918"));

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200707/1

.