N
Nick Halfpenny
Hi,
I'm trying to open a form and the automatically find the
last record within a table using a specific index which is
not the Default one. I've used the following VBA:
Dim DB As Database, rst As Recordset
DoCmd.GoToRecord , , acLast
This will retrieve the last record, in the order they were
entered (default Index), but not on the field I would like
(a date field). I've broused through several Microsoft
book's and I couldn't find very much info on record
manipulation.
Any help would be appreciated.
Regards,
Nick.
p.s. can anyone recommend a good VBA book, that has
relevant practical examples !!!
I'm trying to open a form and the automatically find the
last record within a table using a specific index which is
not the Default one. I've used the following VBA:
Dim DB As Database, rst As Recordset
DoCmd.GoToRecord , , acLast
This will retrieve the last record, in the order they were
entered (default Index), but not on the field I would like
(a date field). I've broused through several Microsoft
book's and I couldn't find very much info on record
manipulation.
Any help would be appreciated.
Regards,
Nick.
p.s. can anyone recommend a good VBA book, that has
relevant practical examples !!!