• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

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
0
shieldsco
Asked:
shieldsco
  • 3
  • 3
1 Solution
 
Gustav BrockCIOCommented:
You can open with a list of values:

strList = "('" & Replace(Me.Proprietary_Credit, " ", "','") & "')"
' Example: "('21100009','88010001')"
DoCmd.OpenForm "frm_Object_Classes", , , "[USSGL] In " & strList

/gustav
0
 
shieldscoAuthor Commented:
I have thousands of rows so that would be impractical
0
 
shieldscoAuthor Commented:
Row 1 21100009 88010001
Row 2 21100009 88010001 57000001
Row 3 10100001
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Gustav BrockCIOCommented:
You wrote you would open a form. Click a button running the code and that will do it.

/gustav
0
 
shieldscoAuthor Commented:
Very Good
0
 
Gustav BrockCIOCommented:
Thanks!

/gustav
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now