Access 2010 Form with multiple values in a field
Posted on 2014-09-23
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 57000001
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 & "'"