I am checking that values have been added to pages in a multipage and
need to set the focus to the tab before i set the focus to the
textbox.

Currently it errors as the page is not in focus....

Here is the code:

'Checks if ADDRESS - LINE 1 is entered
If Me.tbResAddressLineOne = "" Then
MsgBox "Please complete the mandatory 'Address' fields",
vbInformation, mboxheader
'***CODE IN HERE TO FOCUS ON THE MULTIPAGE PAGE BEFORE TRYING TO FOCUS
ON THE BOX***
Me.tbResAddressLineOne.SetFocus
Exit Sub

Help appreciated

Cheers
aaron

Try :

Multipage1.Value = 0 '(Page 0 for first page, 1 for second... )

Before the line :
Me.tbResAddressLineOne.SetFocus

Pierre


"Azza" a écrit dans le message de
m...
I am checking that values have been added to pages in a multipage and
need to set the focus to the tab before i set the focus to the
textbox.

Currently it errors as the page is not in focus....

Here is the code:

'Checks if ADDRESS - LINE 1 is entered
If Me.tbResAddressLineOne = "" Then
MsgBox "Please complete the mandatory 'Address' fields",
vbInformation, mboxheader
'***CODE IN HERE TO FOCUS ON THE MULTIPAGE PAGE BEFORE TRYING TO FOCUS
ON THE BOX***
Me.tbResAddressLineOne.SetFocus
Exit Sub

Help appreciated

Cheers
aaron

Thank you very much

Aaron



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!