و يمكن ايضاً تعديل التسميات لتناسب اسماء الحقول المعنية ... سيتغير الكود الى التالي :
Select Case Forms!frm1.Form!Cmd.Tag
Case 0
Me.aa = DLookup("aa", "tbl1", "id= " & Me.ID)
Me.aaa = DLookup("aaa", "tbl1", "id= " & Me.ID)
Me.lbl1.Caption = "aa"
Me.lbl2.Caption = "aaa"
Case 1
Me.aa = DLookup("bb", "tbl1", "id= " & Me.ID)
Me.aaa = DLookup("bbb", "tbl1", "id= " & Me.ID)
Me.lbl1.Caption = "bb"
Me.lbl2.Caption = "bbb"
Case 2
Me.aa = DLookup("cc", "tbl1", "id= " & Me.ID)
Me.aaa = DLookup("ccc", "tbl1", "id= " & Me.ID)
Me.lbl1.Caption = "cc"
Me.lbl2.Caption = "ccc"
End Select
تفضل المرفق بعد التعديل
بالتوفيق
Tapages2.rar