From: James on 17 Jan 2006 10:37
Im trying to use the OnCurrent event to check the value of a field. If the
field is set to say 6 then it moves to the next record and checks that and
so on until it finds a record where the field in question is set to say 4.
I can seem to get it to work fine when all it has to do is skip 1 record but
if 2 records or more in a sequence are set to 6 then i get a 2105 error
message. Saying I cant go to the specified record.
Ive been using:
DoCmd.GoToRecord, , acNext
Cheers for the help.
From: roadie.girl on 17 Jan 2006 14:56
why don't you use rs.MoveNext ... can you post more of your code that
you're using - it'd help a little...