Results 1 to 4 of 4
  1. #1
    Jay2077 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    6

    Drop Down Assistance Required

    Hi, I am a relatively new user of Ms Access. I have 3 drop downs Region - Sub region - Customer The first 2 work fine however the customer drop down seems to reveal the customer who is one way along to the one it should be showing



    eg North England

    Yorkshire

    customer 4 (when it should be showing customer 3)

    My sub regions are numbered
    then the customers are numbered likewise
    ie Yorkshire 4
    customer a = 4
    customer b = 4

    Can someone please tell me where I'm going wrong ?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    not sure what you are asking.
    the customer drop box should have a query that looks at the subRegion box..

    select customer from table where [subRegion]=forms!myForm!cboSubRegion

    is this what youre asking?

  3. #3
    Jay2077 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    6
    Quote Originally Posted by ranman256 View Post
    not sure what you are asking.
    the customer drop box should have a query that looks at the subRegion box..

    select customer from table where [subRegion]=forms!myForm!cboSubRegion

    is this what youre asking?

    Yeah I have this its picking up the customers only its picking up the wrong customers

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Show the SQL Row Source for the customer combobox.

    A way to debug is to copy the row source into a new query design. After you have selected the sub region go to the query and run it, see what it displays, change the sub region, etc.

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

Similar Threads

  1. Replies: 6
    Last Post: 03-06-2013, 12:17 PM
  2. Replies: 3
    Last Post: 12-30-2011, 01:20 PM
  3. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  4. Lookout wizard assistance required
    By NewInAccessBusiness in forum Access
    Replies: 2
    Last Post: 04-06-2011, 12:40 AM
  5. Assistance on DB Design required - please
    By Optimus_1 in forum Database Design
    Replies: 13
    Last Post: 07-05-2010, 04:38 PM

Tags for this Thread

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