Hi all,
I have some forms for Search & Edit. Let me take an example of Form "Search Edit Members" its Record Source is query "Search Edit Members Query" with Sql:
SELECT Members.MembershipTitle, Members.MembershipType, Members.MemberID, Members.GenderStatus, Members.SurName, Members.GivenName, Members.MembershipStartDate, Members.MembershipExpireDate, Members.DesignationSOC, Members.Dob, Members.MemberEC, Members.Nationality, Members.Organization, Members.OrganizationDesignation, Members.EduQualification, Members.EducationStatus, Members.[Postal Address], Members.MainCityName, Members.TelephoneOffice, Members.TelephoneResidence, Members.FaxNo, Members.MobileNo1, Members.MobileNo2, Members.MemberEmail, Members.SkypeID, Members.ViberID, Members.FacebookID, Members.[CNIC Number], Members.[CNIC IssueDate], Members.[CNIC ExpiryDate], Members.PassportNo, Members.[Passport IssueDate], Members.[Passport ExpiryDate], Members.ProposedBy, Members.RecommendedBy, Members.Working, Members.Photo, Members.Country
FROM Members
WHERE (((Members.Working)=True))
ORDER BY Members.MemberID;
Table Members has Primary Key MemberID and it has one-to-many relationship with table "CST Transaction" when i do edit MemberID on this form, MemberID is updated in table "CST Transaction".
My issue is that if i edit "SurName" and "GivenName" they do not update in table "CST Transaction" and some other tables, in the same manner there may be chance of editing other fields.
I did tried with the After Update event on "SurName" field, but nothing happened may be this is wrong way i am trying.
Private Sub SurName_AfterUpdate()
Dim varV As Variant
varV = DLookup("[SurName]", "CST Transaction")
varV = Me.SurName.Value
End Sub
Need help please.
Khalid
__._,_.___
Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar