Modal form passes sequence without waiting?

[news2]

This MUST be simple.

I have a modal form that asks for entry of one field and has an OK button.

For the only field on the form I have a got-focus sub to load the field with
a default value.

The OK button has a sub to move the contents of the field to an external
public variable and then docmd.close.

What happens is that when the form is opened with

DoCmd.OpenForm "<name of the form>", acNormal

the calling procedure continues to the succeeding statement without waiting
for the form's OK to be hit. The form remains visible.

Hints????

Dick

 

[storrboy]

This MUST be simple.

I have a modal form that asks for entry of one field and has an OK button.

For the only field on the form I have a got-focus sub to load the field with
a default value.

The OK button has a sub to move the contents of the field to an external
public variable and then docmd.close.

What happens is that when the form is opened with

DoCmd.OpenForm "<name of the form>", acNormal

the calling procedure continues to the succeeding statement without waiting
for the form's OK to be hit. The form remains visible.

Hints????

Dick

Hint - acDialog.

 

[Dirk Goldgar]

In

This MUST be simple.

I have a modal form that asks for entry of one field and has an OK
button.

For the only field on the form I have a got-focus sub to load the
field with a default value.

The OK button has a sub to move the contents of the field to an
external public variable and then docmd.close.

What happens is that when the form is opened with

DoCmd.OpenForm "<name of the form>", acNormal

the calling procedure continues to the succeeding statement without
waiting for the form's OK to be hit. The form remains visible.

Hints????

Dick

You need to open it explicitly in dialog mode:

DoCmd.OpenForm "<name of the form>", WindowMode:=acDialog

 

[Albert D. Kallal]

First, don't use a global var to pass, or retrieve values (a bad programming
practice).

To retrieve values from a form, and make the form halt, I explain how here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[news2]

Thanks, that did it. An earlier suggested solution worked but the compiler
complained.

Dick