How To Modify A Field Value?

Hi,

I am trying to change the value of a field (well a few fields once I get it to work for one!) in a table.

I am trying to update the last record in a table, but cannot get any code to work in VBA for this and cannot make an update query select just the last record in the table to do it that way either!

The VBA I am using is:

Dim db As Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Inventory Transactions", dbOpenDynaset)

With rst
.MoveLast
.Edit
![UnitsOrdered] = (Me.UnitsOrdered - Me.Qty_Passed_Insp)
.Update
End With
rst.Close
db.Close

Units ordered doesn't change though!


For the update query I am trying the following criteria for the transactionID field:

=max( [Inventory Transactions]![TransactionID] )

But this returns the error message:

"Cannot have aggregate finction in WHERE clause ([Inventory Transactions].TransactionID = Max([Inventory Transactions]![TransactionID]))"

Any suggestions?

Thanks in advance!