Combo Box Problem - Criteria Change, Values Disappear...

Struggling...

I've got a datasheet in which the user selects a location, and then
based on that selection, they can then select associated sub-locations
from the next combo box (requery onfocus with the second combo - source
is tblSubLocations - one locations has many SubLocations). This all
works fine when the initial location remains the same for subsequent
records.

The problem is when this location is changed, changing the criteria in
the row source of the second combo box and promptly hides the
sub-locations in the records above (which reappear when I click on
them, but hide those below it). Seeing as I've been going around and
around with this all day, I'm keen to hear any suggestions on how I
could fix it.

Previously I've moved the location combo to a parent form and then
filtered the subform datasheet so only those records with that location
are displayed. However, this is a little more time consuming for the
user to change each time so would like to know how the professionals
would do it. I've been through a number of the posts but haven't really
found anything that showed me how to fix it.

Much Appreciated,

Reg

re: Combo Box Problem - Criteria Change, Values Disappear...

Hi,
This site may or may not help you.
http://www.cadellsoftware.org/SampleDBs.htm

Hopefully, it will give you some ideas.
the initial location remains the same for subsequent--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1