>I have a form with textboxes, combos, and a pageframe on it. The third page has a grid with 5 columns.
>I am using a SQL SELECT to populate a temp cursor and zapping the grid.recordsource and appending from the temp. The data is only visible if the query runs while the page the grid is on is the visible page. In fact the status bar tells me no records were selected if the page with the grid is not visible, and when I bring that page forward only the grid lines and headers are there. I would also not like FoxPro to ask me if I want to zap the file.
>
>This is in the LostFocus of a combo box where the user chooses a client.
>

** query to filter sidemark by company code for display in a grid
>
>lcThisClientNumber = thisform.txtClientNumber.value
>
>SELECT Cdm11smk.smk_smark AS cSidemark;
> FROM classicdb!cdm11smk;
> WHERE Cdm11smk.cmp_code = lcThisClientNumber;
> ORDER BY Cdm11smk.smk_smark;
>INTO CURSOR curTmpSidemark
>
>SELECT curSidemark
>ZAP
>APPEND FROM DBF("curTmpSidemark")
>GO TOP
>thisform.pgfClientDetails.pagSidemarks.grdSidemarks.grcSidemark.txtSidemark.value = curSidemark.cSidemark
>thisform.refresh()

>The cursor is created in the Load of the form. How can I get the data into the grid without it being the page on top. Sometimes when the grid is visible, the data in the grid does not change with the selection of a new client from the combo box.

Mathew:

Have you tried placing the code in the InterActiveChange method of the combobox?

- Ravi