Go to Next record loop

[S1LV3RF0X87]

Is it possible when using the go to next record wizard to program it up when it reaches the end record I.e a null record that it resets itself and starts over again so it's on a loop?

 

[theDBguy]

You should be able to modify the resulting code to do what you want. Not sure the Wizard was designed to do that on its own.

 

[S1LV3RF0X87]

Am just thinking on an idea to help streamline a part of our system so it's more user friendly.

Do you have any idea on what the vba would have to be like in order to do this?

 

[S1LV3RF0X87]

The idea for the function is not for the main use of the system.

I have a form that displays an attachment image which would be things like offers an promotions to keep the members informed of whats going on.

I am using traditional wizard commands to navigate through the different promotions backwards an forwards but I was hoping to make the system a little bit more slicker than what it was.

I just want the user to when getting to the end of the next record function rather than see an empty form an having to use the go to previous record function to see previous adverts I.e records that the command would simply just start over again. An therefore not display a blank form.

 

[Isaac]

So you just want the functionality to go 'next', on a bound form, without the possibility that the "next" command ends up at the blank (new record) screen?

 

[S1LV3RF0X87]

So you just want the functionality to go 'next', on a bound form, without the possibility that the "next" command ends up at the blank (new record) screen?

Yes that's all I am after

 

[arnelgp]

like this one?

 

[S1LV3RF0X87]

like this one?

Hit nail on head with that one thanks

 

[arnelgp]

you're welcome