Hi,
We have a table with the following fields:
deptserviceID: department providing the services
staffservicesID: staff name providing the services
PayDeptID: payment made to the department provided the services
PayStaffId
ayment to staff providing the services.
Sometime the department and the staff providing the services are different than the one we pay for some reasons.
To process the payment:
I have payment request combo that I would like if you select any option from it, msgbox pop saying are you paying the same service provider for the services? If yes, then auto fill the following field
PayDeptID Combo, and PayStaffId combo from deptserviceID and staffservicesID. if the response is no, nothing happen the staff will have to pick from PayDeptID and PayStaffId.
Private Sub PaymentStatus_AfterUpdate()
Dim msg As Integer
Dim Response As Integer
MsgBox "Are you paying the same provider for the services", vbYesNo
If Response = vbYes Then
PayDeptID=
........
We have a table with the following fields:
deptserviceID: department providing the services
staffservicesID: staff name providing the services
PayDeptID: payment made to the department provided the services
PayStaffId
Sometime the department and the staff providing the services are different than the one we pay for some reasons.
To process the payment:
I have payment request combo that I would like if you select any option from it, msgbox pop saying are you paying the same service provider for the services? If yes, then auto fill the following field
PayDeptID Combo, and PayStaffId combo from deptserviceID and staffservicesID. if the response is no, nothing happen the staff will have to pick from PayDeptID and PayStaffId.
Private Sub PaymentStatus_AfterUpdate()
Dim msg As Integer
Dim Response As Integer
MsgBox "Are you paying the same provider for the services", vbYesNo
If Response = vbYes Then
PayDeptID=
........