Exclude a field in a subform and calculate birthdays / anniversaries

[Mikey C]

Hi all

I have a main form which displays a specific contacts details and a
subform which displays all contacts for the same company (with a link
which will display the selected alternative contacts details in the
main form if double clicked)


Now ... What I would like to do is exclude the record from the
alternative contacts subform if it is already displayed in the main
form - any idea how to do this?


Also


I'm recording the DOB and relationship start dates for each
operator /
contact. I would like to create a subform that will calculate
birthdays and anniversaries, and then display these for one week
prior
to event until one week after the event (if could be green before
event & red afterwards would be great!!)


Can anyone point me in the right direction?


Please be gentle - as you can tell, I'm a bit of a novice!


Thanks