Hello, I'm new to the Access programming and am having a small problem.
I have a form with a combo box in the main form and a tab control with 2 tabbed pages, each has a subform on it.
Is there a way to click on the combo box so the contents in the subform in the first tab page would change? I've got the following codes for my combo box:
Private Sub CourseID_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CourseID] = '" & Me![CourseID] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Before when I had both subforms on the main form it worked just fine, but the subforms are quite large so I thought putting them in tabs would allow better visibility. Should I have not used the tab control at all?
Thank you for any help.
I have a form with a combo box in the main form and a tab control with 2 tabbed pages, each has a subform on it.
Is there a way to click on the combo box so the contents in the subform in the first tab page would change? I've got the following codes for my combo box:
Private Sub CourseID_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CourseID] = '" & Me![CourseID] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Before when I had both subforms on the main form it worked just fine, but the subforms are quite large so I thought putting them in tabs would allow better visibility. Should I have not used the tab control at all?
Thank you for any help.