Pop-up forms

[klwu]

I have 2 pop-up forms.....eg Form A and Form B....

This is what I want to do:
When form A loads, it will first look for appropriate needed data from a table....
if .eof then form B loads on top of form A for user input....
Q: How can I set focus to form B when it loads?

I tried the DoCmd.OpenForm, but the form loads behind form A.......
thanks in advance

 

[maxmangion]

try putting Me.Form.SetFocus

 

[RoyVidar]

Or try the acdialog option

docmd.openform "yourform",,,,,acdialog

 

[klwu]

I have added the code to form_load on form B.......however it still loads behind form A....thanks anyway

 

[klwu]

thanks max and roy........

after adding both setfocus and acdialog command, form B now loads in front of form A........thanks a bunch

 

[maxmangion]

you're welcome, good to hear that you sorted it out