Form Order

[Cyberjake]

I have a form that when the Zip Code field gets focus, it opens another form where the user can select a city associated with a zip code entered when the query is run. My problem is that when the second form opens, it is behind the main form and I cannot select the correct city without closing the main form. How can I get the second form to open on top of the main form instead of behind it?

 

[hwkranger]

set it to dialog. this can be done if you are using VBA see help docmd.openform or can be set if you are using a macro (open window type dialog)

Randall Vollen
National City Bank Corp.

 

[hwkranger]

that advice looks bad as I look back, what I meant about (open window type dialog) is that SET the window type to Dialog

Randall Vollen
National City Bank Corp.

 

[Cyberjake]

Thanks Randall.
I had the properties of both forms set to dialog and I thought that would work but I guess I was wrong. I coded the form to open as dialog and it works great. Thanks again.

Anthony Robert