L
LMV
How would you update the lngCountPO when the event is bound to a different
field?
(I only need to do this during a build then I will be resetting the field so
it will not be stored except for the short term. BTW I cannot change the
whole concept because the PO# is tied to to many forms etc. I am just trying
to come up with a work around... and I don't know how to write the # to the
lngCountPO and the PO number thanks!)
Private Sub txtFillPO_Click()
On Error GoTo Err_txtFillPO_Click
Me.PurchaseOrderNumber = Me.ProjectID & CStr(DMax("[lngCountPO]", "Orders")
+ 1) & Me.PurchaserID
field?
(I only need to do this during a build then I will be resetting the field so
it will not be stored except for the short term. BTW I cannot change the
whole concept because the PO# is tied to to many forms etc. I am just trying
to come up with a work around... and I don't know how to write the # to the
lngCountPO and the PO number thanks!)
Private Sub txtFillPO_Click()
On Error GoTo Err_txtFillPO_Click
Me.PurchaseOrderNumber = Me.ProjectID & CStr(DMax("[lngCountPO]", "Orders")
+ 1) & Me.PurchaserID