John,
You should use a parameterized view to show the child records. When the parent record changes all you have to do is Requery( "TheChildView" ). You also have to make sure you have a PageRefresher object so that the page will properly refresh. There's code over on my website for the PageRefresher and a sample pview if you've never used them.
>I have a screen form with a number of pages within a Page Frame. All but one of the pages are fields for the primary table it's set up for. One of the pages is a grid for which I want to display records related to the current file and record from another file.
>
>To do this, I set the record source type to SQL and set the SQL statement (record source) to somelike like "SELECT * FROM a_opcusp WHERE a_opcusp.custno = a_arcust.custno INTO CURSOR temp".
>
>Nopw, I'm not sure if I need the INTO command, but regardless of this, I can only get this to work once -- when I enter the screen. When I skip through the primary file the records showing on the grid stay the same.