Can only make certain combo box selections (97)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

Here

Reply | Quote

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?

Reply | Quote

Well, I can physically

Reply | Quote

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 🙂

Reply | Quote

That

Reply | Quote

You’re welcome 🙂

Reply | Quote

Problem though, sorry!

I

Reply | Quote

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.

Reply | Quote

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

Reply | Quote