change focus; disable control

[markjkubicki]

...which lead me to a new problem...




Private Sub cmdAccept_Click()
...
With Forms![frmMainMenu].[cmdFixtureSchedulePrint]
...
.setFocus
End With
Me.cmdAccept.Enabled = False '<--- this is the line that results in an error

I thought that since I've just set focus to another control, it would be OK to disable this control (but maybe since I'm still in the event of that code, I can't)
Would it make sense to move the code to disable cmdAccept to an event on the control I am moving focus to?
and if so, behind which event should that be?

or would there be a better approach?

as always, thanks in advance,
Mark

[Missinglinq]

...Would it make sense to move the code to disable cmdAccept to an event on the control I am moving focus to...

That depends; do you always want the Command Button named cmdAccept to be Disabled when you move to this other Control? If so, use the GotFocus event of that Control; if not so, post back.

Linq ;0)>

[ssanfu]

What is the error message?

Is the button "cmdAccept" on the form "frmMainMenu"?

I tried your code (modified for my forms) and did not get an error.

[Missinglinq]

I'm sure it is on the same form; Error #2164 "You cannot disable a control while it has focus."

Linq ;0)>

[markjkubicki]

I do always want the Command Button named cmdAccept to be Disabled when I move to the other Control cmdFixtureSchedulePrint

cmdAccept is on a subform (unrelated to, but located on) the parent form which is where the other control is

[ssanfu]

Just to make sure I understand,

Button cmdFixtureSchedulePrint is on the main form?

Button cmdAccept is on the subform?

[markjkubicki]

That is correct

[ssanfu]

The main form has a focus and the sub-form has a focus. From the sub-form, if you set (change) the focus on the main form, you don't change which control on the sub-form has the focus.
You have to change which control on the sub-form has the focus.

Private Sub cmdAccept_Click()
 ...
 With Forms![frmMainMenu].[cmdFixtureSchedulePrint]
        ...
        .setFocus  '<<=== only changes which control has the focus on the main form
 End With 

 Me.cmdAccept.Enabled = False '<--- this is the line that results in an error /Me.cmdAccept still has the focus

Try this

Private Sub cmdAccept_Click()
  ...
  With Forms![frmMainMenu].[cmdFixtureSchedulePrint]
         ...
         .setFocus  '<<=== only changes which control has the focus on the main form, not the sub-form
  End With 

  Me.SomeOtherControl.Setfocus  , << a different control on the sub-form
  Me.cmdAccept.Enabled = False '<<== cmdAccept does not have focus, cmdAccept is disabled

[markjkubicki]

makes total sense...
BIG THANKS (yet again)