By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,290 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,290 IT Pros & Developers. It's quick & easy.

Form Tabs-Stop User

P: 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
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.