View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Azza Azza is offline
external usenet poster
 
Posts: 7
Default Using Multipages in a Form

Hey all

I have just started using multipages in a form as I have heaps of info
to extract.

The problem is I do not know how to set the focus from one page to the
next.

I have field validations and when they trigger and the multipage is on
another page I get a notinfocus error.

I have these sort of validations:
'Checks if REFERRAL SOURCE is entered
If Me.cbRefSource = "" Then
MsgBox "Please enter the 'Referral Source'", vbInformation,
mboxheader
Me.cbRefSource.SetFocus
Exit Sub
End If

and need to get the form to goto the page first.

Please help - will be appreciated.

Aaron