Solved Loop through datasheet form (1 Viewer)

[Kayleigh]

I have a form displayed in datasheet view and would like to create a function which loops through all records displayed (or possibly all selected records), open each one at a time and perform a specific function, then close it.
Any tips on how to perform the loop please?

 

[Uncle Gizmo]

the simplest way would be to add a check field/checkbox to the records displayed. The user could select the particular records you wanted to operate the code on. Now run a recordset loop from a command button to do what you want to do to the marked records.

More info here:-

Recordset Loops How To - Nifty Access

Recordset Loops I recently answered a question on my Facebook site... Link:- Full Text of my Answer:- basically it would be best to use a record set loop to solve the OP's problem. I agree with Sherry, you need to use a Recordset Loop... I did a set of video instructions on how to create a

www.niftyaccess.com

 

[Kayleigh]

can this be done in a non-updateable recordset?

 

[Uncle Gizmo]

This is my answer to a somewhat similar question, which I thought might be of interest:-

Move Info from One Table to Another - Nifty Access

Move Info from One Table to Another A brief summary summary of the "OP's" (Original Posters) question HERE. I've done a set of YouTube videos to answer the question. The first answer demonstrates the INSERT INTO method of adding records to another table. This method is where you update the...

www.niftyaccess.com