For Each Loop - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

For Each Loop

Richard Stein

2 years ago

I have a from which displays multiple records. Each record has a checkbox. I select those records I want to run an update for.

How do I loop through each record on the form so I can check the value of the checkbox for that record?

I watched your For Each Loop video which got me to the selected record on the form.

Thanks for your help

	Richard Stein OP @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
Recordsets

	Adam Schwanz @Reply 2 years ago
A recordset would be much easier. `Me.Refresh Dim RS As Recordset Set RS=Currentdb.OpenRecordset("Select * From Table Where CheckboxField=True") While Not RS.EOF rs.edit 'the updates you want to do rs.update rs.movenext wend rs.close set rs=nothing` Edit: I left the page open way too long apparently :P Kevin gave you the answer 15min ago LOL.

	Richard Stein OP @Reply 2 years ago
Thanks guys - I had a totally senior moment. You are helpful

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View