Recordset Loops How To

I recently answered a question on my Facebook site here is a link to the question and you can find my answer in the question, basically it would be best to use a record set loop to solve the OP’s problem  Full Text of my Answer:- 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:- https://youtu.be/r1y_Zl3uLkM?t=1m12s it 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;- https://youtu.be/r1y_Zl3uLkM?t=1m49s and it discusses the operation of that function which is generally termed a “Recordset Loop” If you go to the video at this time index https://youtu.be/r1y_Zl3uLkM?t=3m20s 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