Updating a number of fields at the same time on a continuous form.

[Moss100]

Hello,

I have a continuous form called MOBILES

On this form I have a textbox/field called NUMBERS and textbox/field called SENT

After clicking a button (I was thinking the after update event) I would like the records on the form which have a value in the NUMBERS field of greater than 100 to then update the value of the SENT field from NO to YES.

I can do this on each indivual record, but am unsure how to update all the records on the form at once.

Many thanks for any help,

Mark

 

[PHV]

Why not using an UPDATE query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Moss100]

Thanks I have researched that and will give it a go.