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.