List 7-129 FormEditSlipフォームのCOMBO_CUSTOMER_LostFocusプロシージャ
1: Private Sub COMBO_CUSTOMER_LostFocus()
2: ' 顧客の選択が終わったとき
3: ' 新規顧客であった場合には,その顧客の住所と電話番号をそれぞれ
4: ' 納入先住所,納入先電話番号に格納するようにする
5: Dim CUSTOMERNAME As Variant, YOMIGANA As Variant
6: Dim ZIP As Variant, ADDRESS As Variant, FAX As Variant
7: Dim TELEPHONE As Variant, BILLDAY As Variant
8: Dim MEMO As Variant, MADEUSER As Variant, MADEDATE As Variant
9: Dim LASTUSER As Variant, LASTDATE As Variant
10: Dim listIndex As Long
11:
12: If SlipID = -1 Then
13: listIndex = COMBO_CUSTOMER.listIndex
14: If listIndex <> -1 Then
15: Dim objCustomer As Business.Customer
16: On Error GoTo ErrHandle
17: Set objCustomer = CreateObject("Business.Customer")
18:
19: objCustomer.GetCustomer COMBO_CUSTOMER.ItemData(listIndex), _
CUSTOMERNAME, YOMIGANA, _
ZIP, ADDRESS, TELEPHONE, _
FAX, BILLDAY, _
MEMO, MADEUSER, MADEDATE, _
LASTUSER, LASTDATE
20:
21: If Not IsNull(ADDRESS) Then
22: TXT_SENTADDR.Text = ADDRESS
23: End If
24:
25: If Not IsNull(TELEPHONE) Then
26: TXT_SENTTEL.Text = TELEPHONE
27: End If
28:
29: Set objCustomer = Nothing
30: End If
31: End If
32:
33: Exit Sub
34:
35: ErrHandle:
36: ' エラーハンドラ
37: Set objCustomer = Nothing
38: End Sub