Returning information on form used as a dialog

[jodyblau]

I'm new at this stuff, so let me know if I am approaching this
incorrectly.

I have a form that allows the user to select a document that is in one
folder, and copy it into another folder. I would then like it to
rename that file based upon a name provided by the user.

So far, once the user clicks on the button to start this process, I
open a form which has its pop up and Modal properties set to true.

I would like the function which opened the form I am using for a dialog
box to wait for the user to enter the information before continuing on
with its process. (like you would expect a dialog box to do.)

Can someone explain how I would go about doing that? or is there some
dialog control that I should be using instead?

Thank you,

Jody Blau

[Wayne Gillespie]

On 6 Feb 2006 18:42:30 -0800, "jodyblau" <jo******@gmail.com> wrote:

I'm new at this stuff, so let me know if I am approaching this
incorrectly.

I have a form that allows the user to select a document that is in one
folder, and copy it into another folder. I would then like it to
rename that file based upon a name provided by the user.

So far, once the user clicks on the button to start this process, I
open a form which has its pop up and Modal properties set to true.

I would like the function which opened the form I am using for a dialog
box to wait for the user to enter the information before continuing on
with its process. (like you would expect a dialog box to do.)

Can someone explain how I would go about doing that? or is there some
dialog control that I should be using instead?

Thank you,

Jody Blau

DoCmd.OpenForm "frmMyForm",,,,,acDialog
Wayne Gillespie
Gosford NSW Australia

[jodyblau]

I tried this, but it doesn't wait for the dialog to close before
continuing on with the code.

eg.,

private sub Add_Document()

DoCmd.OpenForm "Name_File_Dialog", , , acDialog
MsgBox "BOO"
end sub

I need the dialog box to return a vaule before the code continues to
execute, e.g., so the dialog box should pop up, the user should enter
info, and then close the dialog box, before I get MsgBox "Boo" to
execute.

Thanks,

Jody

[pamelafluente]

You have to show it in a modal form. Not modeless.
aiaiai

-Pam

[salad]

jodyblau wrote:

I tried this, but it doesn't wait for the dialog to close before
continuing on with the code.

eg.,

private sub Add_Document()

DoCmd.OpenForm "Name_File_Dialog", , , acDialog
MsgBox "BOO"
end sub

I need the dialog box to return a vaule before the code continues to
execute, e.g., so the dialog box should pop up, the user should enter
info, and then close the dialog box, before I get MsgBox "Boo" to
execute.

Thanks,

Jody

What you can do is 1) close the form if the person doesn't complete the
action or 2) make the form hidden if item selected.

DoCmd.OpenForm "Name_File_Dialog", , , acDialog
If IsLoaded("Name_File_Dialog") Then
'see function IsLoaded at http://groups.google.com
Me.Text0 = Forms!Name_File_Dialog!Text0
Docmd.close acForm ""Name_File_Dialog""
endif
MsgBox "BOO"

[Wayne Gillespie]

On 6 Feb 2006 20:11:49 -0800, "jodyblau" <jo******@gmail.com> wrote:

I tried this, but it doesn't wait for the dialog to close before
continuing on with the code.

eg.,

private sub Add_Document()

DoCmd.OpenForm "Name_File_Dialog", , , acDialog
MsgBox "BOO"
end sub

I need the dialog box to return a vaule before the code continues to
execute, e.g., so the dialog box should pop up, the user should enter
info, and then close the dialog box, before I get MsgBox "Boo" to
execute.

Thanks,

Jody

If the code above is a direct copy from your app, then you are using an
incorrect syntax. The WindowMode argument (acDialog) is the 6th argument of the
OpenForm action, there should be 5 commas between FormName and WindowMode (not
3).

DoCmd.OpenForm "Name_File_Dialog", , , , , acDialog
Wayne Gillespie
Gosford NSW Australia