>You're overwriting the rowsource of the grid everytime you do a select, thus blanking it out. Instead of a temp table, how about using a parameterized view? Then you can set the parameter to whatever the combobox selected, and requery the grid to display the new information.
Very interesting idea. Only thing is I don,t know how to do it.
What I'm trying to do is basically a drill down option.The mani table has about 30000 records with a unique invoice no. field. The user may need to reprint a particular invoice. So I need to show the numbers for selection. What I do is say do a select as such:
Select invoice_no,.F. as selection from invtable into table a_temp where year(inv_date) = 1998.
This is displayed in the grid and the selections field is as check boxes so the user can tick the reprints needed.
I have a combo box loaded with the years 1996, 1997, 1998. So when user selects 1997 the same select is run but the 1997 records are pulled out. I used to use a mover type screen but since this screen is also used for other reports and the user has the option of selecting ALL, the screen is ineffecient as I have to use an array and build up the selections in another array as the ADDITEM method using FOR is too too slow when the number of records can be >10000.
Can you shed some more light on your above idea. Currently have a another solution that works by re setting the properties in the grid to the new cursor and then doing a refresh.
Thanks Jerry
Bernard