combo box dilemma

[talus7]

OK! I am relatively new to the access world, but I have managed to
create a small database. I have an issue with some combo boxes and a
form. I have two combo boxes synchronized using queries and row sources
as many online guides have instructed to do so. I have one combo box
with a list of countries and the second combo box has a list of store
ids in each country. When I select the country's it requeries fine, but
for example if i were to select Argentina a list of the store ids is
displayed. When I select the store ID the combo box will only display
the item in the first row, but if I select the rest it will not select
that item. Any suggestions? I will provide more details as requested.
All the help is highly appreciated.

 

[Guest]

That usually happen when the first column repeat itself, so it jumps to the
first record.
If the RowSource of the store combo include the country Id, and the country
id is the first column, and the combo is bounded to the first column, it will
always jump to the first store in that list because the country id repeat it
self.
If that the case move the country id, to be the last filed in the list, and
instead put the store field as the first one.

I hope it make sense, and I didn't confuse you more.

 

[talus7]

Ofer,
Thanks for the feedback, and I did what you said, but I am still
getting the same result. I am using a query on both combo boxes as the
row source. On my storeID query I changed the country column as you
instructed. I have some basic vba code running to requery the country
combo so that the right list of store id shows up. Its really
frustrating I have everything setup right on this form. I have even
additional information been dumped into text boxes, but when I select
one country its list of id stores will not allow me to select the id
and show in the combo box. I just want to assure the user that they are
choosing the right store id, and that the text information that they
see is correct.

 

[Ron2005]

When you select the store ID you do NOT want to requery the country
because that will inturn cause the store id box to itself be requeried.

You do not want to requery anything from the id box unless it is solely
dependent on store id.

Think of it as if it were state, city and address When you select
address there is no need to re-examine State of City.

Ron

 

[talus7]

Thanks Ron and Ofer. I finally figured it out, it was a silly mistake
where I accidentally changed the bound column and did not notice it. I
checked the field yesterday and notice that the wrong column was set.
You guys are awesome thanks for all your support.