F
Fev
Hi
I have a form that displays when a text box "Member Name"is clicked in
a form "Household Members", and am using the IsLoaded Function from
NorthWind. I would like the form Family_Member to remain open but
show another member when it is clicked from the calling form - ie
clear the previous filter and apply a new filter without unloading and
reopening the form. Is this posible?
Private Sub Family_Member_Click()
If IsLoaded("Church Member") Then
Me.Filter = "[PersonalID]=""& Me.PersonalID"""
Me.FilterOn = True
Me.Requery
Else
DoCmd.OpenForm "Church Member", , , "[PersonalID]=" &
Me.PersonalID, , acDialog
End If
End Sub
Thanks
I have a form that displays when a text box "Member Name"is clicked in
a form "Household Members", and am using the IsLoaded Function from
NorthWind. I would like the form Family_Member to remain open but
show another member when it is clicked from the calling form - ie
clear the previous filter and apply a new filter without unloading and
reopening the form. Is this posible?
Private Sub Family_Member_Click()
If IsLoaded("Church Member") Then
Me.Filter = "[PersonalID]=""& Me.PersonalID"""
Me.FilterOn = True
Me.Requery
Else
DoCmd.OpenForm "Church Member", , , "[PersonalID]=" &
Me.PersonalID, , acDialog
End If
End Sub
Thanks