Connecting Tech Pros Worldwide Help | Site Map

Form Tabs-Stop User

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 08:25 PM
DD
Guest
 
Posts: n/a
Default Form Tabs-Stop User

I have x2 tab forms place in a mainform.

with the following code..
I want to stop the user going to Case 2 when case 1 has no EmployeeID


Dim sf As Control
For Each sf In Me.Controls
If sf.ControlType = acSubform Then sf.Visible = False
Next
Select Case ActiveControl
Case 1
Me.Employee.Visible = True
Case 2
Me.fsubEmployeePersonal.Visible = True
Case Else
End Select
Me.MainTab = ActiveControl - 1
Exit Sub

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.