Shafid -
Try this:
Put your variable name ( e.g., l_cclient) in the control source on the property sheet.
Initialize your variable in the init of the form.
Do your seek in the valid either using procedural code or a select statement like the following:
Select* from names where names.clientcode=l_cclient

The same approach should get you through the stock number problem.

Your calculations and running totals could be done in the report form.

I hope that helps.

Eleanor

>I am new to vfp6. I am trying to make an invoice form. At the top I want to create a variable to input
>the client code then want to seek the varibale in names.dbf and find the right client and show the name
>and address etc. Then below this, I want to show :
>Stock No Description Price Qty Total
>-------------- ----------------------------------------- --------------- ---------------- ---------------
>
>At the stock code I want the user to fill int the stock code variable and search the stock using the var
>in the stock file, then show the desc, price. Then type in the qty and work out the total. Then go
>to next line and carry on making the invoice. At the bottom I want to show the running total. Each
>invoice line I want to save in invoice data file etc. I have been at it for last few days, but I can not
>pass the value to seek the database and have no idea hoe to work on stock section. I have no
>problem printing an invoice. Can anyone help ????? Please ????