Dear HiTechCoach:
Yes, I love your idea of #2 which keeping the linked fields ,by the way, your suggestion with Nz() is more simple than my IsNull() to check combo B_year.
Coach just cure my headache and I like to say thank you again and again. :)
ps. I don't know why #1 can't work in Access 2007.