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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement