>I have a multi-page form and one of the pages has a grid on it that I want to populate based on a SQL statement. I have set the RecordSourceType to "4-SQL statement" and I have set the RecordSource to the SQL statement itself. When I run the form I can see the grid with the correct values for the first record I am viewing with my form but when I move to another record the grid doesn't update. Does a grid that has a SQL statement for its RecordSource only run the query once? What's the best way to make the SQL statement be executed each time I navigate to another record? The SQL statement I am using is as follows (formatting added while writing this message):
>
>
>select asetdetl.sensor_id, sensors.desc
> from asetdetl, sensors
> WHERE ASetDetl.sensor_id = sensors.id AND
> ASetDetl.acc_set_id = asetmast.acc_set_id
> into cursor setmembers
>
>
>The table asetmast is the master table that I want to navigate and have the query run each time I go to another record.
It will make things much cleaner for you if you put your SQL statement in a form method, have its results go into a cursor, and make the grid's recordsource that cursor. Then refreshing the grid is as easy as:
THISFORM.mygrid.RecordSource = ""
THISFORM.RunMyQuery()
THISFORM.myGrid.RecordSource = "MyCursor"
Erik Moore
Clientelligence