R
Rick Roberts
Acc 2003 – ADP – SQL Server 2000 - VBA
I am developing a PO system for a client. I have a form with 2 sub forms. In
this particular case the main form (“PurchaseOrdersâ€) record source will
always have one record; the PO header record. The 2 sub forms have the same
record source (the PO Line Items), one with a continuous display and one with
a single record display. The continuous sub form is not updateable, it is
used strictly as means to navigation to the individual Line Item record for
updating. Line Item adds happen outside the scope of this question.
Is there a way I can use the same recordset for both sub forms? Using a
recordset clone? When I update a line Item I would like NOT to have to
requery the continuous form. What I am trying to avoid is going back to the
server to get a fresh copy after each line item update yet keep the forms in
sync.
What is the best method for an ADP?
I am developing a PO system for a client. I have a form with 2 sub forms. In
this particular case the main form (“PurchaseOrdersâ€) record source will
always have one record; the PO header record. The 2 sub forms have the same
record source (the PO Line Items), one with a continuous display and one with
a single record display. The continuous sub form is not updateable, it is
used strictly as means to navigation to the individual Line Item record for
updating. Line Item adds happen outside the scope of this question.
Is there a way I can use the same recordset for both sub forms? Using a
recordset clone? When I update a line Item I would like NOT to have to
requery the continuous form. What I am trying to avoid is going back to the
server to get a fresh copy after each line item update yet keep the forms in
sync.
What is the best method for an ADP?