Hi

I have a button that runs an append query based on criteria entered via a pop-up box. I want to beable to run the append query several times. Currently I press the button each time I want to append. Is there a way to code a loop on the button where the parameter pops-up and the user enters the criteria?

Hi

Welcome to UtterAccess (IMG:style_emoticons/default/welcome2UA.gif)

Yes, you can do what you want but we could do with some more info from you to be able to help. For example, how are you determining how many times the loop will run (ie how many records are being appended), and as you're using the same criteria it could be that you're creating many duplicate records ? If that's right, then it would be a bit of an odd thing to want to do.

Perhaps you could also give some more info on the purpose to creating the records in the first place, as there may be a better solution for you

If Alan's not on to something (bad design), then you could do it easily by prompting the user with a form with a multi-select listbox on it. the user could choose whatever items he wanted, then just loop through the ItemsSelected collection of the listbox and process away.