Refresh open Recordset

[bee55]

Hi Every body,
i have this ode:

set RsItems = db.openrecordset("Items"
RsItems.Addnew
RsItems!Quantity = RsItems!quantity + 10
Rs!Items.update
Me!Total = RsItems!Quantity
RsItems.close

The displayed Value in (total ) is an old value not after adding 10
the problem is the table Items not refreshed
how can i refresh the table before displaying Quantity in (total)
answers will be highly apriciated

 

[bob fitz]

Have you tried:

set RsItems = db.openrecordset("Items"
RsItems.Addnew
RsItems!Quantity = RsItems!quantity + 10
Me!Total = RsItems!Quantity
Rs!Items.update
RsItems.close