On open event to open another form

[Blorf]

Hello.

I have a db with a main form. There are some records waiting for purchase order numbers, and I have a form that displays them, allowing the user to either enter a PO or specify a date they expect to receive one.

Any way, the main forms on open event checks to see if there are any pending PO's, and if so, opens the other form.

However, I can't get the main form to open the other form, and give focus to it. Even with the .setfocus it wont do it. It opens it, but puts it behind the main form.

Any idea of how to make have focus?

Thank you,
ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[lupins46]

make it a popup and modal.