>I have a modal form that is being called from a command button on a maintenance form. The modal form contains a grid. One of the columns in grid contains a combo box that accesses a table with about 5000 records.
>
>Here is a list of the problems I am having:
>
>First: When the modal form is finished loading, 'most' of the time you can still see the controls from the underlying maintenance form. It apppears that the modal form's background is transparent!
>
>Second: The combo box accessing 5000 records is VERY slow. The screen is constantly redrawing everytime the user tries to select an item in the drop-down combo box.
>
>Third: Moving from row to row in the grid is very slow. I'm sure this has to do with the large number of records in the combo box.
>
>Any suggestions?

Darrell,

1. Is a consequence of 2 and 3 but you might want to lock the screen until the design phase is finished.

2. It is a bad design decision to use a combo to select from among 5000 items. It's even worse for a combo placed on a grid.

3. Just for testing purposes remove the combo from the grid. You should see a radical improvement.

That said, the design is still problematic in my opinion. Why do you want to browse 5000 records at a time? Can't you filter the data somehow. I'd suggest to use a parameterized view.

José