Go to Next record loop (1 Viewer)

[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?

 

[Pat Hartman]

It is extremely rare to loop through a recordset in a form. Not unheard of but rare. Forms work on one record at a time and interact with the user. Processing a recordset is a batch process akin to printing monthly invoices or paychecks. You are probably making work for yourself. We can only help you though if you tell us what you are trying to accomplish. Your question doesn't do that. You have made an assumption that you have chosen the correct technique. You just don't know how to implement it but it is more likely that you actually haven't chosen the correct method to accomplish your actual business goal.

 

[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