Update Multiple Records 1

[GlenMacK]

Can anyone send me in the right direction how to update multiple records at one time.

I have form that brings up WorkOrders that have not been printed. I have a button on the form that when clicked it prints all the new work orders, but I want to have all the records updated for the WorkOrderPrinted field to equal yes at the same time

Any ideas on how to do this. Currently the user has to print each one separately in order for it to be marked printed.

TIA

GlenMacK

 

[RoyVidar]

Think this calls for some "looping thru the form recorset".

Lot of threads concerning that on the site, heres one, thread702-742853.

Hope this is something in the direction you need.

Roy-Vidar

 

[GlenMacK]

Thanks Roy...The information worked perfect....