Insert set text on clik

[captnk]

I am looking for a way that when i clik/or dblclik,on a field in a record (in a form/datasheet)it will delete the existing text and replace it with another "preset" text expression.
From that expression I also need it to delete or clear values from 1 or 2 other columns so that a recalculation can occur minus the item designated by the above situation.
Any ideas welcome
Captnk

 

[wizcow]

In the field's properties in click or double click event, assign a macro.
build the macro using the 'setvalue' function.

 

[captnk]

Wizcow !!!
BRILLIANT !!!!
Many thanks works great.

Will have a look at Pat's view as well,its just so nice to be able to move on.
Actually I intend to save the changed/deleted items to a new temp table and the with the use of "if" statement be able to reverse the changes,with a similar procedure.
Again many thanks

 

[captnk]

PAT.
Thanks yr view and help.
I have just switched over from lotus approach,which despite all its bugs,was in many instances a bit more intuitive than access,so i'm struggling here,and all help is appreciated.

Yes I think yr right,I will ultimately have to put that in code,(its a bit unstable using the macro.)
As for my "bright idea" to be able to retore from a temp file using an if statement doesnt work from a Macro.
I can save the deleted item to a temp file,find it again in a query,but for whatever reason I cant put the found items back in the form.
(my form is a sub form,so their is no table to update or append to,but even so it wont update back to the main subformtable).
It really has got me stuffed as to why I cant put the found item back.
Any ideas pls.