Go to Control / Set Focus

K

K

Hello,

I have a form called frmMillMenu. It is a pop up menu (form) that you can
run different queries from. On Close how do I code it so it goes to a form
called frmRates and sets the focus on a field called ESTRATE? the frmRates is
a subform in a form called frmMain. Any help would be appreciated. I have
tried

Forms![frmMain]![frmRates].SetFocus
Forms![frmMain]![frmRates].FORM![ESTRATE].SetFocus

I get an error 2110 that it cannot move to the control ESTRATE?

Any help would be appreciated. Thanks Kyle.
 
K

K

Ops!! Got it. I had it set focus on a control that wasnt enabled. Sorry if I
wasted anyones time in reading this. Cheers, Kyle.
 

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

Copy Paste - Subform 1
Continuous Forms subform referenced by subform 2
Go to Field? 3
SET FOCUS ERR.2165 4
Setting the focus to a field on a subform within a tab control 4
Requery main form after subform update and not lose place in main form. 1
Copy / Past - From a form to a subform 1
Public object scope doesn't last 2

Top