G
google3luo359
I'd really appreciate some help with this one.
I have a tabbed form with a subform.
I use the following code to open up a certain tab when the user logs
in:
If Me!cboUserID.Column(2) = 9 Then
Forms![fmAP]!TabAP.Pages(0).SetFocus
I need to have code now, that when the user clicks on say Tab Page (1),
data from Table AP that belongs to this same UserID is displayed which
has 10 as a value in Table AP's Grade field.
Similarly if the user clicks on Tab Page (2) the following formula
would be used:
Page 0 = 9 (Grade field)
Page 1 = 10
Page 2 = 11
Page 3 = 12
Any help would be appreciated!
Ric
I have a tabbed form with a subform.
I use the following code to open up a certain tab when the user logs
in:
If Me!cboUserID.Column(2) = 9 Then
Forms![fmAP]!TabAP.Pages(0).SetFocus
I need to have code now, that when the user clicks on say Tab Page (1),
data from Table AP that belongs to this same UserID is displayed which
has 10 as a value in Table AP's Grade field.
Similarly if the user clicks on Tab Page (2) the following formula
would be used:
Page 0 = 9 (Grade field)
Page 1 = 10
Page 2 = 11
Page 3 = 12
Any help would be appreciated!
Ric