Results 1 to 2 of 2
  1. #1
    Swin69 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    3

    Trying to create a text field dependent query

    Hi All,



    I'm trying to create a form where I have a text field labeled customer and a list box based upon a query labled production parts. What I'm hoping to accomplish is that when the customer's name is typed in the text field, the list box will populate with only the customer's production parts. Any ideas?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    It would be conceptually the same as this:

    Baldy-Cascading Combos

    I would likely use a combo for the customer anyway, to avoid misspellings and such.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Validation dependent Text
    By Arrrggggjhhhhh!!!! in forum Forms
    Replies: 3
    Last Post: 02-27-2012, 07:36 AM
  2. Creating a query with a self-dependent field
    By lottrup in forum Queries
    Replies: 0
    Last Post: 06-20-2011, 04:30 AM
  3. Replies: 4
    Last Post: 02-08-2011, 08:43 AM
  4. Replies: 0
    Last Post: 12-16-2009, 09:28 AM
  5. Setting a field to be dependent on another
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-19-2008, 11:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums