What's going on

[alib9]

I didn't know what to search for on this one so if anyone could help me then I would be most grateful.

When I run the app, it auto runs a form which I later hide (otherwise it won't go away).

If I then load another form, the program displays it but then carries on executing the rest of the code.

Is there any way (well there must be), to get the user to do something else i.e put an input in, and then carry out a few tasks, before continuing to execute the rest of the code.

Any help would be great.

Thanks in advance

 

[yauncin]

What application are you running your code from?

 

[JohnYingling]

You need to use a modal form.
formname.show vbModal
to stop execution until the form is hidden or unloaded.
I usually call a procedure in the form an do a
me.Show vbModal there. When execution resumes I get the values I want to return into local storage, do a me.unload and return the values (unload will clear form level variables if you do a
Set formname = Nothing
which is the only way to completely unload the form).

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[JohnYingling]

Just realized that this the VBA (as opposed to VB) forum so I do not if VBA forms work in a similar fashion.

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[alib9]

That worked fine thanks JohnYingling