Opening a form in a Do Cycle

[Maracay]

Hi guys,

I have a do cycle, and depending on some conditions I need to stop the cycle
and open a pop form to modify the data of the current record, after I close
the pop form, the cycle should continue to the end of the file or stop again
to modify the current record.

I don’t know how to stop the cycle after opening the form, what actually
does is open the form if the condition is fulfill but the cycle goes to the
end.

Any help will be appreciated

Thanks

 

[Marshall Barton]

I have a do cycle, and depending on some conditions I need to stop the cycle
and open a pop form to modify the data of the current record, after I close
the pop form, the cycle should continue to the end of the file or stop again
to modify the current record.

I don’t know how to stop the cycle after opening the form, what actually
does is open the form if the condition is fulfill but the cycle goes to the
end.

Open the form in dialog mode (instead of popup modal) to
stop you code until the form is either closed or made
invisible:

DoCmd.OpenForm "the form", WindowMode:=acDialog