combo box selection disappears

[jonnie]

What's wrong here?

I have a form where the user selects a school term and department using two combo boxes. The two selections are passed to a query which displays a subform. The term box contents are created by a query. The department box is a lookup. THE PROBLEM IS: The first time the form is loaded, if you select a term, your selection immediately disappears. If you select the department from the second box, everything works OK, the term selection appears in the first box and the results are displayed. Is there any way to make the combo box selection stay visible?

Many thanks in advance.

 

[LarryDeLaruelle]

Jonnie:

Look in the After Update Event for the Term Combo. From your description it appears that the visible property of the combo box is being set to false.

Did you create this app or design it yourself? I've worked with inherited applications and they can be quite a bit of fun to figure out especially if they are poorly documented.

Let me know if this helps or not.

 

[jonnie]

Thanks Larry,

Unfortunatley, I inherited this application, and it has about five forms with this same problem. They all use combo boxes to select data that is displayed in a subform. All of the combo boxes have requeries in their AfterUpdate event, but the first time the form is loaded, the selection disappears immediately after you select it. The value is still there, because the query from the other combo box works just fine. The visible property of the Combo box is set to yes. Anybody got any ideas?
again, thank you.