VB Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Building WHERE clause
    ... I want to condition the results on dates and "premium" ... I have a search form where I enter the beginning date and ending ... for min and max Premium amounts in my search form. ... One thought I had was that the HAVING clause was causing ...
    (comp.databases.ms-access)
  • Re: Null input returns all values using wildcards
    ... Switch the query to SQL view, and craft the WHERE clause so it returns TRUE when the parameter is null. ... Search form - Handle many optional criteria ...
    (microsoft.public.access.queries)
  • Re: 2 extreme newbie ?s
    ... > completely oblivious as to which libraries to look in. ... > Dim num As Double ... > If I want num to be set to 8.93, which method of the String class should I ... > clause to function the way I want it to. ...
    (microsoft.public.dotnet.academic)
  • Re: LIKE in embedded if statement?
    ... Switch the query to SQL View, and adjust the WHERE clause like this: ... Replace "Field1" with the name of your field. ... If you are interested in building your own search form using code to avoid these convoluted clauses, ... Search form - Handle many optional criteria ...
    (microsoft.public.access.queries)
  • HELP! Selecting Array Rows based on an array of field=>value s
    ... foreach($retvi as $num => $row){ ... //DONE LIMITING TO WHERE CLAUSE ... return $retvi; ...
    (comp.lang.php)