Force Access to reveal active page.

[dkaplan]

Is there any way to force Access to reveal which page object it considers active? I have two tabs on a form (the page objects) and my code (it's running a search) needs to know which object is currently active. Visible = true doesn't work, as Access seems to regard both tabs as visible at all times. Suggestions?

 

[DougP]

Did you look at ....
ActiveControl Property Example

The following example assigns the active control to the ctlCurrentControl variable and then takes different actions depending on the value of the control's Name property.

Dim ctlCurrentControl As Control

Set ctlCurrentControl = Screen.ActiveControl
If ctlCurrentControl.Name = "txtCustomerID" Then
. ' Do this.
.
.
ElseIf ctlCurrentControl.Name = "btnCustomerDetails" Then
. ' Do this.
.
.
End If
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[dkaplan]

Thanks.
With a little digging around I discovered that the following also works, specific to tabs (or as MS calls them 'page objects.')

if (me.tabCtrl.value = 0)
do this
else
do that
end if

'value' is the page index property of the page object.