Solved

Access 2010 Form with multiple values in a field

Posted on 2014-09-23
6
253 Views
Last Modified: 2014-09-24
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
Comment
Question by:shieldsco
  • 3
  • 3
6 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40341080
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
 

Author Comment

by:shieldsco
ID: 40341176
I have thousands of rows so that would be impractical
0
 

Author Comment

by:shieldsco
ID: 40341186
Row 1 21100009 88010001
Row 2 21100009 88010001 57000001
Row 3 10100001
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 49

Expert Comment

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

/gustav
0
 

Author Closing Comment

by:shieldsco
ID: 40341358
Very Good
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40341364
Thanks!

/gustav
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question