Using Last()

[puthenveetil]

Hi all,

Is there anyway to use Last() feature in load event?. I would like to find the last value in the balance amount when the form load.

I would like to use like this..

Me.Bal_amt = last([Bal_amt])

When I open form an error message is popping up error 13 .


Is there any way I can use this function.


Thanks in advance


Thanks

 

[Big2]

.MoveLast command would do it mate.

you'd have to open a recordset and then use a with statement to get there

Set BLA = CurrentDb.OpenRecordset("Table")

With BLA

.MoveLast​

VariableName = Bal_amt​

End With

With the recordset you could just a SELECT statement and just select the balance field from your table.