Call Refresh() method of the grid after you moved to the next record.
>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.
--sb--