Enable button in the master form when clicking in the detail

[DistillingAccess]

Hi,

I would like to know how the best way to disable a button every time its focus is NOT in the detail and enable when a line in
a grid in the detail is selected (clicked). The button is located in the master.

I've done that but did't work:
Private Sub cmd_LostFocus()
Me.cmd.Enabled = False
End Sub

It gave me the error:
Run-time error '2164'
You can't disable a control while it has the focus

I also tried to play with the Subform/Subreport events On Enter and On Exit as follow:

Private Sub sub_Enter()
Me.cmd.Enabled = True
End Sub

Private Sub sub_Exit()
Me.cmd.Enabled = False
End Sub

It worked to enable and disable. However, when I am in the grid in the Subform and try to click in the bottom that is in the
FormHeader, it raises the event Exit and, therefore, disable the botton. Any other solution?

Is there a way for me to say in the sub_Exit like this?

Private Sub sub_Exit()
If NOT Me.cmd.Click Then
Me.cmd.Enabled = False
End if
End Sub




Thank you in advance.

Regards.

[DistillingAccess]

Does anyone knows more or less what could be done here?

Thank you in advance.

[RuralGuy]

Perhaps if you describe the function of this button on the MainForm someone would be able to offer a suggestion. Is your SubForm in Datasheet mode?

[DistillingAccess]

Hi RuralGuy,

Thanks for your message. However, I just want to enable or disable the buttom, whatever its function is. The selection type for the master is a Section and the detail is a grid inside a Subform/Subreport.

Regards.

[RuralGuy]

You can reference a MainForm with either the Me.Parent syntax or go through the Forms collection.

[DistillingAccess]

I understood what you meant but don't know what is the syntax to do what I need.

Following your suggestion, I would need something like:

Private Sub sub_Exit()
If NOT Me.Parent.cmd.Click Then 'Doesn't work
Me.cmd.Enabled = False
End if
End Sub

[RuralGuy]

I'm not sure what you meant when you said:

I would like to know how the best way to disable a button every time its focus is NOT in the detail

[DistillingAccess]

Let's pretend I have two forms, A and B. In the form A I have a bottom. I only want to enable the bottom when I am with the cursor in the form B. If I leave it -- the form B--, the bottom in the form A should be disabled.

[RuralGuy]

So you should be able to disable the Command Button in the GotFocus event of the SubForm.