DoCmd GoToRecord

  • Thread starter Thread starter James Freeman
  • Start date Start date
J

James Freeman

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.
 
why don't you use rs.MoveNext ... can you post more of your code that
you're using - it'd help a little...
 
Back
Top