MS Access 2016. Synchronize two combo boxes on a form datasheet

Question

I have two cascading lookup table comboboxes on a Datasheet form.(SessionCategories - SessionTypes). I'm having the following problems:

1) When the form loads I only see the values from the SessionTypes that correspond to the first SessionCategories ID.

2) When I change a value on the SessionCategories combo, all the SessionTypes values change across the datasheet and not only the selected.

Any ideas? Do I need to include something on the Form Load? More info and a couple of different approaches below.

Thanks.

ATHLETE_SESSION table
sessionOverviewID
sessionTypeID

SESSION_CATEGORIES
sessionOverviewID   sessionOverview
1   aerobic
2   anaerobic 


SESSION_TYPE
sessionTypeID   sessionType sessionOverviewID
1   anaerobic1  2
2   anaerobic2  2
3   anaerobic3  2
4   aerobic1    1
5   aerobic2    1
6   aerobic3    1

sessionCategoriesID lookup properties:
Display control: Combo Box
Row Source Type: Table/Query
Row Source: SessionCategories
Bound Column: 1
Column Count: 2
Column Widths: 0cm;2cm

sessionTypeID lookup properties:
Display control: Combo Box
Row Source Type: Table/Query
Row Source:
Bound Column: 1
Column Count: 2
Column Widths: 0cm;2cm


1st approach:

Private Sub comboSessionCategories_AfterUpdate()

Dim strSQL As String
strSQL = "SELECT SessionType.sessionTypeID, SessionType.sessionType FROM SessionType WHERE (((SessionType.sessionOverviewID)=" & [Forms]![Session]![comboSessionOverview] & "))"
Me.comboSessionType.RowSource = strSQL

End Sub

2nd approach:

Private Sub comboSessionCategories_AfterUpdate()

Me.comboSessionType.RowSource = "SELECT SessionType.sessionTypeID, SessionType.sessionType" & _
" FROM SessionType WHERE SessionType.sessionOverviewID=" & Me.comboSessionOverview
Me.comboSessionType = Me.comboSessionType.ItemData(0)

End Sub