Update query in event procedure for Form

[ppc]

Hi

I have created one form with labels as ScripName,LTP1,LTP2,LTP3.

1.Now i want to write an event procedure for On Click event.I want to run the
following update query when i click on LTP1 label
UPDATE ppc500 INNER JOIN bse500 ON ppc500.ScripCode = bse500.ScripCode SET
bse500.LTP1 = ppc500.ltp;
( ppc500 and bse500 are my two tables )

2.When i click on label LTP2 the same query should execute with LTP1 replaced
by LTP2
( With New data imported in the above two tables )
3.When i click on label LTP3 the same query should execute with LTP2 replaced
by LTP3
( With New data imported in the above two tables )

regds

prasanna