I have defined 3 public variables:
Expand|Select|Wrap|Line Numbers
- Public OldCompany As Variant
- Public OldLast As Variant
- Public OldFirst As Variant
Expand|Select|Wrap|Line Numbers
- OldCompany = !Company
- OldLast = ![Last Name]
- OldFirst = ![First Name]
Expand|Select|Wrap|Line Numbers
- With rs1
- .Index = "PrimaryKey"
- .Seek "=", OldCompany, OldLast, OldFirst
Could someone help me please?
Thank you!
Philippe