SaveRecord command

[Guest]

I am working on a database very similar to Northwind.mdb. Each time I add a
product to the subform in a Order Form. an update query is run in the
subform's BeforeUpdate event and inventory amounts are updated in the
products table. But before the updates take effect in the table after every
new entry in the subform, I have to go up the the menu and click on Save
Record or Shift + Enter on the keyboard. Is there not a way that I can
automate the saverecord process each time I add the new product record to the
Order Details Form?

Thanks

 

[Arvin Meyer [MVP]]

You probably need to requery your database after the record has been written
to the database. Try adding a bit of code in the subform's after update
event:

Sub Form_AfterUpdate()
Me.Requery
End Sub