Connecting Tech Pros Worldwide Help | Site Map

Form Tabs-Stop User

  #1  
Old November 12th, 2005, 09:25 PM
DD
Guest
 
Posts: n/a
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
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Submitting forms by clicking on text-based tabs as opposed to SUBMIT button Alex answers 5 December 28th, 2006 07:15 PM
Tabs and ComboBoxes Repost Steve B. answers 11 November 29th, 2005 01:26 AM
Need help: How to Repaint a User Control with Dynamic ASP Link Buttons RSB answers 0 November 18th, 2005 10:08 AM
Dynamic form possible? CAD Fiend answers 3 November 13th, 2005 01:04 PM
Displaying first record of subform in parent form. tdmailbox@yahoo.com answers 5 November 13th, 2005 07:38 AM