Opening a form in a Do Cycle

  • Thread starter Thread starter Maracay
  • Start date Start date
M

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
 
Maracay said:
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.
Click to expand...


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
 
Back
Top