Open form as a class - windowmode

[MissyEd]

Hi

Im opening a form as a class - but I would like to make it open in dialog mode. Mainly because I need to user to make a selection from the form before the code in the main form continues to execute.

Any ideas ?

Heres my code

Dim clsPrintList As Form_frmPrintList
Set clsPrintList = New Form_frmPrintList
With clsPrintList
.refno = Me.fileid
.Form_LoadFiles
.PTypeID = 1
.Form_Show <--- i want to stop here and wait for the use to select something from this form.
End With


Missy Ed - Bolton, UK

 

[JeremyNYC]

Make the form modal. =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[MissyEd]

Hi

The form is modal and pop-up and its border is set to dialog - no joy Missy Ed - Bolton, UK

 

[MissyEd]

PS

I also tried to set the modal property via code ie. .modal = true - but still no joy Missy Ed - Bolton, UK

 

[DanJR]

The code won't stop.....

The code only stops when you open the form via the &quot;docmd.openform&quot; method.

With your method, you could put a loop in the code to check if the form is visible/open.

Cheers,
Dan

 

[MissyEd]

Thanks for your help Dan. I havent been able to access tek-tips all week, but your idea worked a treat. Missy Ed - Bolton, UK