Access Subform Linked to Field using Wildcard
Posted on 2013-12-12
We have Office 2010. In Access 2010 I have a form named frmDocket with a field named Initials. On this form I'd like to add a SubForm to an existing form named frmDktAtty that has a field named RouteTo. I'd like to define which fields link my main form (frmDocket) to the subform (frmDktAtty). I'd be linking frmDocket.Initials to frmDktAtty.RoutedTo
Form field Subform Field
My problem in the Initials field only contains one initial per record:
My RouteTo field contains multiple initials like the following:
JDP, GAP, AXT, LDM
MEN, LDM, CLT, FRG
PXT, JDP, JJK
Therefore I need to link the field with the equivalent of the following, however, I can't see a way to do this with a subform.
Initials = (Like "* [RoutedTo]*")
Can anyone assist me with this.
Thanks in advance!