If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tabbed Subforms
I have a form that also has a Tab subform on it. There
are 4 tabs on this subform. What I would like to do is put a security level on the 4th and last tab so that only certain users can view the information that is on this tabbed subform screen. Does anyone know how this can be accomplished? |
#2
|
|||
|
|||
Tabbed Subforms
On Fri, 9 Jul 2004 10:28:09 -0700, "Ron"
wrote: I have a form that also has a Tab subform on it. There are 4 tabs on this subform. What I would like to do is put a security level on the 4th and last tab so that only certain users can view the information that is on this tabbed subform screen. Does anyone know how this can be accomplished? Of course you mean a Tab control *on* a subform. ;-) Assuming you have workgroup security enabled then use the Tab's change event to validate the CurrentUser Along the lines of... ================= Private Sub tabOrders_Change() Dim ctlTab As Control Dim pge As Page Set ctlTab = Me.tabOrders Set pge = ctlTab.Pages(ctlTab.Value) If pge.Name = "pgRestricted" Then If CurrentUser [the ok user account] Then 'Then send them back to the first page of the tab control. Me.tabOrders.Pages(0).SetFocus End If End If '.....And so on - Jim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data entry forms and/or subforms | Hugh Crean | Using Forms | 2 | July 8th, 2004 05:56 PM |
Calculating totals on a main form from values contained in subforms | John Baker | Using Forms | 5 | July 7th, 2004 11:47 AM |
Adding recs from subforms | TracyG | General Discussion | 2 | June 14th, 2004 06:51 PM |
Problem with subforms in multidatabase project | David G. | Using Forms | 0 | June 10th, 2004 04:23 PM |