Link to home
Start Free TrialLog in
Avatar of shieldsco
shieldscoFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shieldsco

ASKER

I have thousands of rows so that would be impractical
Row 1 21100009 88010001
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
Very Good
Thanks!

/gustav