Hello,
I have make a u "SEARCH RECORD Form" in vba to find records using Invoice Numbers. When I enter invoice number its shows me Date of purchase ,Customer Name, & Amount Which is Due. Its working fine.
In this Form I aslo make 2 more text boxes.
TextBox1= New Payment Received Box
TextBox2 = Total Amount Due Box
Now I want when a customer pays any further amount . It should update the record in the same existing row in Sheet by looking its invoice number which I enter to find record. NOT in the new row.
For Example
In WorkSheet I have the following Columns.
Date Of Purchase Invoice Number Customer Name Total Bill Amount Received Amount Due
2/July/2013101 John $8000 $5000 $3000
Now when I use my Search Record Form and enter invoice number it shows me these details above..
Now lets say this customer pays me $3000 which was its remaining payment. When I put $3000 in "New Payment Received Box" , it will show $0 in "Total Amount Due Box". Now I want when I use Update command it should show me like this...
Date Invoice Number NameAmount Received Amount Due
2/Jan/2013 101 John $3000 $0
It should not update any other columns. It should update only "Amount Received Column & Amount Due Column"
I hope you guys will understand what I mean..
Thank You
Regards
z-eighty2
Bookmarks