Another challenge with cascading combo boxes

[MFB via AccessMonster.com]

I'm having a problem with cascading combo boxes. I'm using the entry in
Box1 to control the contents of Box2. My row source for Box2 references
the Box1 control in it's where clause. I am also requerying Box2 when Box1
changes. The two combo boxes are on a form that is a continuous form. The
combo boxes work correctly when entering data in the first record on the
form. When entering data into Box1 on a subsequent records, the value in
Box2 of Record1 disappears. I believe this is because the bound column for
both combo boxes is not one that is displayed. If I display the bound
column, the form works correctly. Unfortunately, the bound column is an
internal id and isn't what the user wants to see. Is there something I can
do to address this other than displaying the bound column?

Thanks in advance for any help.

 

[Nikos Yannacopoulos]

Assuming you have two columns in Box1; the first one is ID and must be
bound, the second is description and must be displayed. Set the combo's
properties as follows:

Column Count: 2 (tab Format; this makes both columns part of the combo's
rowsource)

Bound Column: 1 (tab Data; this makes the first column, ID, be returned
when bombo is referenced, or stored to a table if bound)

Column Widths: 0;1 (tab Format; this sets the width of the first column
to 0 so it's not displayed at all, user sees only the second column
whose width is 1 or whatever positive number)

HTH,
Nikos

 

[MFB via AccessMonster.com]

Nikos,

Thanks for the information but, unfortunately, it doesn't address my
problem. I guess my description wasn't clear enough with my description.
The issue was with the behavior of Box2 when Box1 is updated on subsequent
records within the continuous form (the values in Box2 are dependent upon
the selection in Box1). I think I found a solution in another thread
(http://www.accessmonster.com/Uwe/Forum.aspx/access-forms/12959/Cascading-
Combo-Boxes) . Thanks again.

 

[Nikos Yannacopoulos]

Yes, that's indeed different.

 

[Gee...]

I've been having trouble with these things myself. I found this site very,
very helpful:
http://www.fontstuff.com/access/acctut10.htm