For Each Loop

[amfroehlich]

I am wanting to write a for each loop that changes on value of one feild in a tabular form.

Example:

For Each PrimaryKey in Form
if checkbox.value = true then
Status = "Complete" 'Change vaule of Status to complete.
end if
Loop

How do i do this with code?

Thanks

 

[Norie]

You've almost got the syntax right for a For Each loop - just replace Loop with Next.

Yo help further more information/explanation is needed.

What is PrimaryKey? A control/field on a form?

What is checkbox?

What is Status?

 

[amfroehlich]

i have a text box with the dual primary key on the form

I have a check box next to every list of items on the form
if the check boxed is check i want to save the information if is not check leave it alone.

Status is the field that i want to change...

 

[Norie]

Why do you want/need to use a loop?

 

[amfroehlich]

Becuase it is a tabular form and i have mulipte items rows displaying.

 

[Norie]

In tabular form each record has it's own form.controls and you should only need to write code once, for the form rather than each record.

Unless I'm not quite understanding you.