Subform Option Group Toggle Buttons Does Not Display Data In Parent Form

Question

I have a continuous subform which contains an option group of 2 toggle buttons.

I have an After Update event which run's a query based on the case (See below).

Private Sub FramePatrolDisplay_AfterUpdate()

Select Case Me.FramePatrolDisplay
    Case 1
        Me.RecordSource = "Qry_Status_Subform"
   Case 2
        Me.RecordSource = "Qry_Status_Subform_Fire"
  End Select

Me.Refresh

End Sub

When I open the subform in Form View, the data populates as expected when each of the toggle buttons are pressed.

The problem I'm having it that when I open the Parent form, the subforms toggle buttons does not dispay any data.

Answer 1

After much fooling around with the subform and the parent form, I was able to resolve my issue.

By selecting the subform from within the parent form I'm able to see the property sheet associated with the subform. On the data tab, I had to "Link Child Field".

I did not need to "Link Master Fields" since the subform is not dependent upon data from the Parent. The subform is only there for a displaying records from another table.

Answer 2

Thanks for the sharing. You did a gread job.