Recordset Loops How To

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 Checklist in an MS Access database. One part of the video covers the record set loop. If you have a look at this video “1 – Adding a Checklist to MS Access” at this time index:- 

The Video clip above gives you an overview. The video discusses the function on the left, which is something similar to What You Want. Move on through the video to this time index;- 

In the video clip above I discuss the operation of that function which is generally termed a “Recordset Loop” If you go to the video at this time index 

That’s the bit you need to change, listSets and listID refer to fields in the record set passed into the record set loop. You need to provide your own SQL statement based on your own tables and then change listSets and listID to the particular fields in the tables from your project you have passed in then check the contents of those variables which represent the fields past in. With regard to deleting a row, off the cuff so to speak without attempting to do it myself, I think I would add an extra field to your table, a boolean field, and write the code to flag the field(s) you want to delete. You can see more about how Record Set loops work from the accompanying Google slides Here:-  List To Data 

 The complete set of videos along with a download of the sample database are available on my website here:- Add a Check List to your MS Access Database

…         ..         ..            ..        ..          ..           ..     ..  ..         … 

… …

Leave a comment

Do you need a hand in the right direction?

You are in the right place.