cascading combo problem

[Tara]

I recently added a cascading combo box to a form. It
works fine for the most part and the value I choose is
stored correctly in the table. The only problem is that
when I go back to look at the form later, the value I
chose in the 2nd combo does not show up. I assume this
is because the values in the 2nd combo are generated by a
query that is set to run when I make a choice in the 1st
combo. However, I really need to be able to go back and
look at the form and see which value I chose. Is there a
way to have the 2nd combo box show the value that was
stored in the underlying table until/unless I change the
value in the 1st combo (which causes the query for the
2nd combo to run)? Does that make any sense???

Thanks!
Tara

 

[Sandra Daigle]

Hi Tara,

Using the Current Event of the form, requery the second combo (the same way
you requery it in the AfterUpdate event of the first combo). That should do
it for you.

 

[Tara]

Thanks so much Sandra! That was it...It seems to work
perfectly now!!!

Tara

-----Original Message-----
Hi Tara,

Using the Current Event of the form, requery the second combo (the same way
you requery it in the AfterUpdate event of the first combo). That should do
it for you.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I recently added a cascading combo box to a form. It
works fine for the most part and the value I choose is
stored correctly in the table. The only problem is that
when I go back to look at the form later, the value I
chose in the 2nd combo does not show up. I assume this
is because the values in the 2nd combo are generated by a
query that is set to run when I make a choice in the 1st
combo. However, I really need to be able to go back and
look at the form and see which value I chose. Is there a
way to have the 2nd combo box show the value that was
stored in the underlying table until/unless I change the
value in the 1st combo (which causes the query for the
2nd combo to run)? Does that make any sense???

Thanks!
Tara

.