>I have created a combobox class & a form class. whenever the user clicks the combo or dropdown action take place the form is displayed.
>the form has a private data session and creates a cursor from the data collected from the combobox list property and displays in grid control.
>This helps searching on multiple columns and many other options.
>But every time the form is created and data collected which can be slow for large datasets.
>
>How do i create the dropdown form once and recreate it only when the rowsource is changed.
>Rajesh
Create once, and don't release. Instead, when it's done, hide it. Keep a reference to it in the caller form, so when you next need it, just show it. If the rowsource is changed, just repopulate its grids, or simply have another form like that, one for each rowsource. So it may be a tad slow only the first time.