Wednesday, May 02, 2012 4:20 PM
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
Me.RecordSource = "Qry_Status_Subform"
Me.RecordSource = "Qry_Status_Subform_Fire"
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.
- Edited by Sheree P Wednesday, May 02, 2012 4:21 PM
Wednesday, May 02, 2012 7:57 PM
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.
- Marked As Answer by Sheree P Wednesday, May 02, 2012 7:58 PM
Thursday, May 03, 2012 5:54 AM
Thanks for the sharing. You did a gread job.