>hi,
>
>i mean i use the code and i know what kind of tables i want,as programmer
>
>but i need to do another code if any user whant to make same via form.
>
>as I suggested: "replace FIELD with NEWVALUE in TABLE for CONDITION"?? sorry i don't undersatnd what you mean and how i can do it.

This was a template/example of how to set it out - not the definitive answer

You have the replace statement in the form:

replace in TABLE for CONDITION FIELD with NEWVALUE

Now, you should show where you are now (this thread is getting too complex) - i.e. what changes you have made, some comments on what you try to achieve with each line, and what errors you gat and where.

>

>CLOSE all
>   lcTable1 = alltrim(thisform.text5.value)
>   lcTable2 = alltrim(thisform.text6.value)

So these get the names of the 2 tables from the user.  Right?

>    Use ( lcTable1) in 0
>    Use ( lcTable2) in 0

> lcField = alltrim(thisform.text1.value)

This gets the name of the field to change, from the user?

>

>replace IN  lcTable2 ;&& Too few arguments
>   FOR EVAL(lcField)==LookUp(lcTable1.&lcfield), EVAL(lcField), (lcTable1.&lcfield)) AND NOT EOF('lcTable1');
>NEWVALUE with VAL(lcTable1. bill_value)

>
Is this what you have now? NEWVALUE is just my example. You must state what you want to replace. I hope that simplifying the statement can help you see where the error is.

>
>