I'd just like to point out that attention to detail is enormously important in development. Particularly in Office applications where the syntax isn't checked as heavily for you be the compiler. It will save you much heart-ache when you take the point on board.
Another very helpful tip that you'll benefit from immensely if you take it on board, is that proper indenting of code can be enormously helpful and save you a lot of effort further down the line. OTOH badly indented code, such as you've posted, is much worse even than none at all. It will confuse a reader and give clues that are actually false. A very dangerous practice.
Anyway, As I see that this is pretty well resolved already (and I've assigned a Best Answer for you) I'll just offer up a minor change to your code to make it easier to maintain :
- Me.Tenant_Contacts.Form.Archived = Me.Archived
-
End Sub
This replaces all of :
- If Me.Archived = True Then
-
Me.Tenant_Contacts.Form!Archived = True
-
ElseIf Me.Archived = False Then
-
Me.Tenant_Contacts.Form!Archived = False
-
End If
-
End Sub