Yes I see the point. The tables are as you say. I need as you said to have 2 dlookups one for the delegate and one for the event and then look for matches of both. so do have something like:
Code:
estartdate = DLookup("[EventStartDate]", "tblEventDelegate", "DelegateID = " & Me.DelegateID)
delid = DLookup ("[DelegateID]","tblEventDelegate", "EventStartDate = "& Me.cmboEvents.Column(1))
and then something like:
Code:
If Abs(DateDiff("d", estartdate, delid, Me.cmboEvents.Column(1))) <= 14 Then
MsgBox "You have scheduled this delegate onto an event within 2 weeks"