I am trying to understand the navigation forms.
I have 2 forms [fromMemberDB] and [frmCases]
I have dragged and dropped these 2 forms into a Navigation form [frmMemberNav]and I can switch between the 2 with the tabs.
In [fromMemberDB] there is a field called "MemberID" and in [frmCases] there is one with the same Name "MemberID"
I need that the "MemberID" from [frmCases] equals the one from [fromMemberDB].
I need to place some VBA and the first question is where. In the NavigationSubform? Or is it in the actual texbox for the "MemberID" on the Navigation form?
I've tried different things with the code:
Me.MemberID=Forms![frmMemberNav]![NavigationSubform].[Form]![MemberID]
Would the right event to place it in be "Before Update"?
Can I get some help with this, please?
I have 2 forms [fromMemberDB] and [frmCases]
I have dragged and dropped these 2 forms into a Navigation form [frmMemberNav]and I can switch between the 2 with the tabs.
In [fromMemberDB] there is a field called "MemberID" and in [frmCases] there is one with the same Name "MemberID"
I need that the "MemberID" from [frmCases] equals the one from [fromMemberDB].
I need to place some VBA and the first question is where. In the NavigationSubform? Or is it in the actual texbox for the "MemberID" on the Navigation form?
I've tried different things with the code:
Me.MemberID=Forms![frmMemberNav]![NavigationSubform].[Form]![MemberID]
Would the right event to place it in be "Before Update"?
Can I get some help with this, please?