Focus after DblClick

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I would like to open a form and set the focus to a particular control on that
form by double-clicking on a particular textbox on another form. The
following code, when put in the click event of a button, does the job just
fine. However, the same code in the double click event of a textbox, opens
the form as expected but leaves the focus (or returns focus) on the textbox
that was double-clicked.

Code:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &
Me.Job_Number & Chr(34)

Note that the on load event of the newly opened form includes the
appropriate code to set the focus to the correct control. My problem is
really just keeping focus on the newly opened form...I think.

Thanks,

Keith
 
Add the line:

[Forms]![frmStockLocation]![TextboxNameYou Want].SetFocus

after the Open form line.
 
Arvin,

Thank you for the response. I tried what you suggested, but I got the same
results. Following is the code in the DblClick event:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &_
Me.Job_Number & Chr(34)
[Forms]![frmstocklocation]![stock location].SetFocus

Do you have any other ideas why the focus isn't staying with the newly
opened form?

Thanks,

Keith


Arvin Meyer said:
Add the line:

[Forms]![frmStockLocation]![TextboxNameYou Want].SetFocus

after the Open form line.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Keith said:
I would like to open a form and set the focus to a particular control on
that
form by double-clicking on a particular textbox on another form. The
following code, when put in the click event of a button, does the job just
fine. However, the same code in the double click event of a textbox,
opens
the form as expected but leaves the focus (or returns focus) on the
textbox
that was double-clicked.

Code:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &
Me.Job_Number & Chr(34)

Note that the on load event of the newly opened form includes the
appropriate code to set the focus to the correct control. My problem is
really just keeping focus on the newly opened form...I think.

Thanks,

Keith
Click to expand...
Click to expand...
 
Keith said:
I would like to open a form and set the focus to a particular control on
that
form by double-clicking on a particular textbox on another form. The
following code, when put in the click event of a button, does the job just
fine. However, the same code in the double click event of a textbox,
opens
the form as expected but leaves the focus (or returns focus) on the
textbox
that was double-clicked.

Code:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &
Me.Job_Number & Chr(34)

Note that the on load event of the newly opened form includes the
appropriate code to set the focus to the correct control. My problem is
really just keeping focus on the newly opened form...I think.
Click to expand...

I'm not observing this behavior. Do you have any code in the Click event of
the text box? The Click event will fire before the DblClick event.
 
The only reason that it might not work is that you have other code running
after it which takes the focus either back to the calling form, or there's
code on the called form in the Open, Load, or Current event which interferes
with this code.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Keith said:
Arvin,

Thank you for the response. I tried what you suggested, but I got the
same
results. Following is the code in the DblClick event:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &_
Me.Job_Number & Chr(34)
[Forms]![frmstocklocation]![stock location].SetFocus

Do you have any other ideas why the focus isn't staying with the newly
opened form?

Thanks,

Keith


Arvin Meyer said:
Add the line:

[Forms]![frmStockLocation]![TextboxNameYou Want].SetFocus

after the Open form line.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Keith said:
I would like to open a form and set the focus to a particular control on
that
form by double-clicking on a particular textbox on another form. The
following code, when put in the click event of a button, does the job
just
fine. However, the same code in the double click event of a textbox,
opens
the form as expected but leaves the focus (or returns focus) on the
textbox
that was double-clicked.

Code:

DoCmd.OpenForm "frmStockLocation", acNormal, , "[JOB_NO]=" & Chr(34) &
Me.Job_Number & Chr(34)

Note that the on load event of the newly opened form includes the
appropriate code to set the focus to the correct control. My problem
is
really just keeping focus on the newly opened form...I think.

Thanks,

Keith
Click to expand...
Click to expand...
Click to expand...
 
Back
Top