Open a form without transferring focus

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
 
G

Guest

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
 
G

Guest

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set focus in a specific record within a subform 1
Set Focus to Record Selector? 1
Focus to SubForm Control 10
setfocus on form control, not subform 4
force focus on a query from a form 1
Access form control focus 1
How to set Subform Default Focus 1
listbox and set focus 1

Top