Open a form without transferring focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to open a form without transferring focus to it? I want to
get user input on a record to look-up and display it in a separate window
(form) but I want to continue interaction with the user in the first form
before transferring focus to the second form. This second form has a
sub-form itself so I don't want to make it a subform of the first form. Is
that about as clear as mud?

Thanks for your help.

Will
 
Hi, traveler.

AFAIK, the OpenForm method intrinsically transfers the focus. But no reason
you can't simply transfer the focus back:

' OpenForm call
Forms!MyFirstForm.SetFocus

Sprinks
 
hi,
I don't think so but you can transfer focus back to the
original form after opening the second form.

Docmd.OpenForms "form2", acNormal
DoCmd.SelectObject acForm, "form1"
 
Back
Top