Urgent - Updating a recordset

Hi all you gurus!
I've got a problem again...
My problem is that I've got to text boxes which are connected to a recordset. One displays the price and the other one displays the installment I've added a variable to it. What I want to do is if I type something in the Installment textbox, it must automatically deduct the info entered from the the Price, and then update the recordset immediately, so that all the other forms show the "new" price.
How can I do this¿
Please email me if this problem is unclear.
Please help, it's very Urgent!
Thanx.


F. T. W.

try without recordset...

in each form U declare


private withevents MY_TXTBOX as textbox

private Sub Form_Load()
set MY_TXTBOX = frmMain.txtPrice
end sub

private Sub MY_TXTBOX_Change()
debug.print "somone is changing txtprice in frmmain!"
End Sub




<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>