I have an order entry form that calls a another form to allow a user to put a deposit on their account. When they come back from the second form, I want to update the first form with that information. It doesn't seem to be working.

This is the code that updates the despoit amount on the customer record:

UPDATE customers SET deposit = customers.deposit+cash_t.applied,lastdate = postdate,lastpay = ;
postdate WHERE customers.custno = ALLTRIM(cash_t.custno)

When I debug it, it appears to work fine and I can even browse the table and the updated amount is there.

Here is the code that I am using to update the screen:

SELECT deposit FROM customers INTO CURSOR deposit_view WHERE custno = combocomp.custno
THISFORM.pageframe1.page1.txtdeposit.VALUE = THISFORM.pageframe1.page1.txtdeposit.VALUE + deposit_view.deposit

The problem is that the deposit_view.deposit field still contains the value of customers.deposit BEFORE the table was updated.

What am I missing?? Please help.

Randy Wessels