I have a PO form (frmPO), with the following command buttons, "Next PO", "Previous PO", "Top of File", "Bottom of File", "Add A New PO".....etc.

When moving through the PO file using the above button, I also display the PO items withing a grid, linked to the PO_Items table. I create the following view at the LOAD() event of the frmPO to display the items:

CREATE VIEW lvPO_Items AS;
SELECT ITEMCODE, NAME, QTY, UNITPRICE, DATE_REQUESTED, DATE_PROMISED, COMMENT FROM PO_Items WHERE PONO=PO.PONO

How can I refresh the items in the grid list if the user selects "Next PO", or "Previous PO".....

DO I have to Delete the View and ReCreate it as follows?

DELETE VIEW lvPO_Items

CREATE VIEW lvPO_Items AS;
SELECT ITEMCODE, NAME, QTY, UNITPRICE, DATE_REQUESTED, DATE_PROMISED, COMMENT FROM PO_Items WHERE PONO=PO.PONO
ThisForm.pgfPO.pgPO.grdPO_Items.RecordSourceType= 0
ThisForm.pgfPO.pgPO.grdPO_Items.RecordSource= "lvPO_Items"

Thanks in advance?