I have a database I have built that houses Warranty claims. They are uniquely identified by claim number.
We regularly get a cheque which has certain dollar amount that need to be applied to certain claims.
I want to write a procedure where the user enters the cheque number and then in a table enters the Claim numbers and amounts. Once the procedure runs it would find each Claim Number the user entered and update the claim with the cheque number and dollar amount.
I am not looking for the coding per se, but the best approach to take in order to achieve this. Table, schema, query, string?
So far I have:
Code:
Private Sub Command6_Click()
Dim CQNum As String
Dim WoNum As Integer
Dim Amount_Paid As Currency
CQNum = InputBox("Please enter the Cheque Number you wish to Process.", "Cheque Number")
If StrPtr(CQNum) = 0 Then
MsgBox "Cancel Was Selected"
Exit Sub
ElseIf CQNum = "" Then
MsgBox "You did not enter a Cheque Number"
Exit Sub
End If
DoCmd.OpenTable "Cheque", acViewNormal, acAdd
End Sub