I'm wondering where the issue is, or if it has to do with this. Essentially when you open the front end, a form open with a list of various years to choose from. this years reads as follows:
Private Sub Label4_Click()
DoCmd.DeleteObject acTable, "Resident Info"
DoCmd.TransferDatabase...