arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 11:59
- Joined
- May 7, 2009
- Messages
- 19,246
i think there is no need for Filtering or changing Recordsource of
TargetSubform.
Add a dummy Textbox (txtLink) to the Main Form.
On the Current Event of the SwForm (first subform),
set the value of this textbox:
Private sub Form_Current()
Me.Parent!txtLink = Left(Me!Num & "", 2)
End Sub
Now create a Master/Child Linkfields to TargetSubform:
Link Master Fields: [txtLink]
Link Child Fields: [theFieldYouWantToLink]
TargetSubform.
Add a dummy Textbox (txtLink) to the Main Form.
On the Current Event of the SwForm (first subform),
set the value of this textbox:
Private sub Form_Current()
Me.Parent!txtLink = Left(Me!Num & "", 2)
End Sub
Now create a Master/Child Linkfields to TargetSubform:
Link Master Fields: [txtLink]
Link Child Fields: [theFieldYouWantToLink]