>SO my view just gets the ONE record I want, but to go to another record, I must close the view, change the select statement memory variables and open the table again.

Joel,

Try changing the memory variables and then issue a REQUERY on the view.

Kind Regards,

Mat