trystanhuwwilliams
Programmer
Hi i wonder if anyone would know this? I want to get a field value from the recordset. I've got a date field in the table xflag which is tested for the current date at the opening of the switchboard. If the test doesn't find today's date as the last record then emails are sent out otherwise no action is taken.
I realise the best way to do this is using the recordset, but how do you get a variable to return the value of the last record entered??
This is what I've got so far..
I realise the best way to do this is using the recordset, but how do you get a variable to return the value of the last record entered??
This is what I've got so far..
Code:
Dim RS As DAO.Recordset
Dim DB As DAO.Database
Set DB = CurrentDb()
Set RS = DB.OpenRecordset("XFLAG")
With RS
.MoveFirst
.MoveLast
End With
[\code]
Thank you,
T