Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can only make certain combo box selections (97)

    Can only make certain combo box selections
    The row source type for my bound control is from a table. The rowsource is a query based on the table. Essentially combo shows a retailer and retailer store number as well as the retailer name. What I

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Can you post the query? Or something else that will give more information?

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Here

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Is it that you physically can't select other stores from the combo, or when you select a store it always does the next process as if you've chosen the first store?

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Well, I can physically

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    You'll have to check how many columns you are using in the combo and which column is bound. Since you have so many columns in the query behind the combo, my guess is that you've made RetailerNumber the bound column rather than the combination of RetailerStoreNumber. When the user selects from the combo, only RetailerNumber is passed and it's just selecting the first record that relates to RetailerNumber, which is Store 0001.

    Also, is your calculated column also available in the records that you want to go to? You might have to create a single unique key that is available in both and use that to refer to the next step (you didn't say what you're doing with the combo data once a selection is made).

    Let me know how you make out.

    Cecilia :-)

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    That

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    You're welcome :-)

  9. #9
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Problem though, sorry!

    I

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    I'm not sure what you're doing with the results of the combo box, but if you're displaying records based on the choice, you can always write code that combines the two (ie. cboMyCombo.Column(1) & cboMyCombo.Column(2)) and combines them in the destination for comparison.

    I know, clear as mud. But it would help to know what step you're doing next.

  11. #11
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can only make certain combo box selections (97)

    Well the combo has 10 columns most of which are hidden, they

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •