Re: How to force refresh of a list box when form loads
First off, I have followed the AJAX video example to set up two combo list boxes on a form. The second combo list box criteria is provided by combo list box 1.
The problem is:
Assume the data source for the combo list box 1 contains just one record.
When the form opens, the first and only record is selected and displayed.
Combo List Box 2 has several records that can be selected & displayed based on the criteria provided by combo list box 1
The problem is that when the form opens combo list box 2 does not display any data. I suspect the generated code is structured for an input on combo list box one on the data changed event. In other words, the user is expected to make a selection from the first combo list box before the refresh on combo list box 2 is triggered.
However, since there is only one record in combo list box 1, the data changed event cannot be triggered, so the data refresh on combo 2 cannot occur.
PS: It works OK when combo list box has TWO or more records, so maybe this is more of a bug in the code generation. There are a few other things I have noticed that suggest the AJAX code generated does not function adequately for more complex forms, such as when the form has several combo list box, each dependent on the previous one providing data selection criteria.