Looping a record selection via a combo box

[samonwalkabout]

Is it possible to loop the record selection ie. when you get to the last record it goes back to the first rather than hitting a blank record (new record). I am using a combo box for record selection so VB code would do the job maybe??????

 

[spacepro]

Take a look at this thread and the db I attached the code is something like:

With recordset
.movenext
if .eof then .movefirst
end if
end sub

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43990

Andy