shieldsco
asked on
Access 2010 Form with multiple values in a field
I have an Access form with multiple values in a field separated by a space in the following format:
Field(Proprietary_Debit) .....Sample Data (Text)
21100009 88010001
21100009 88010001 57000001
10100001
I would like to drill down to and another form and display the data that matches. The code below works for non-multivalued fields:
DoCmd.OpenForm "frm_Object_Classes", , , "[USSGL]='" & Me.Proprietary_Credit & "'"
Thanks
Field(Proprietary_Debit) .....Sample Data (Text)
21100009 88010001
21100009 88010001 57000001
10100001
I would like to drill down to and another form and display the data that matches. The code below works for non-multivalued fields:
DoCmd.OpenForm "frm_Object_Classes", , , "[USSGL]='" & Me.Proprietary_Credit & "'"
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Row 1 21100009 88010001
Row 2 21100009 88010001 57000001
Row 3 10100001
Row 2 21100009 88010001 57000001
Row 3 10100001
You wrote you would open a form. Click a button running the code and that will do it.
/gustav
/gustav
ASKER
Very Good
Thanks!
/gustav
/gustav
ASKER