<div>
Have you considered storing a valiable on the click event of the tabs?
</div>


Have you considered storing a valiable on the click event of the tabs?

<div>
To find which control has focus use: Forms!FormName.ActiveContr<wbr />ol.Name<br />
<br />
You can use then in a If:Then statement to check your tab.<br />
<br />
Dim ActiveCTL as Control<br />
ActiveCTL = Forms!FormName.ActiveContr<wbr />ol.Name<br />
<br />
If YourControl = ActiveCTL then<br />
&nbsp; &nbsp; &nbsp;' Do something if True<br />
Else<br />
&nbsp; &nbsp; &nbsp;' Do something if False<br />
End If<br />
<br />
I'll have to check this out tomorrow morning as I typing on the fly (dangerous for me), but think I'm in the BallPark...<br />
<br />
Imoutwest <br />

</div>


To find which control has focus use: Forms!FormName.ActiveControl.Name

You can use then in a If:Then statement to check your tab.

Dim ActiveCTL as Control
ActiveCTL = Forms!FormName.ActiveControl.Name

If YourControl = ActiveCTL then
     ' Do something if True
Else
     ' Do something if False
End If

I'll have to check this out tomorrow morning as I typing on the fly (dangerous for me), but think I'm in the BallPark...

Imoutwest


<div>
Thanks, yes that's what i needed!
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
how can i detect if a tab (or any other object) has the focus?<br />
<br />
I can set the focus like this : Forms![Main]![&amp;Fields].Set<wbr />Focus<br />
but instead i want to detect if it has the focus.<br />
<br />
Thanks<br />
<br />
<br />
<br />

</div>
</div>


Hi,

how can i detect if a tab (or any other object) has the focus?

I can set the focus like this : Forms![Main]![&Fields].SetFocus
but instead i want to detect if it has the focus.

Thanks





Detect if tab has focus

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.