>Hello
>
>I have a order entry form , when making a new order i have to check if they paid for old order , if not paid i have to display a form with all the unpaid orders and allow user to update it
>
>how to do it.
>
>Txs
I believe you just answered your own question. :) Seriousely, you have all steps defined, all you need to do is something like SQL select for unpaid orders, make the resulting cursor the RecordSource for your grid, and when you select the particular record in the grid fire up your form where you edit orders.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison