Hi. I'm hoping someone can help me with this search question...

MT_Position / PK = PositionID
MT_Candidate / PK = CandidateID
MT_Interview / PK = FirstName, LastName, Email / FK = PositionID, CandidateID

I have a tabbed form. On tab 1 is the main form (recordsource = MT_Position).
On tab 2 is a sub form (recordsource = QryCandidateInterview). The subform
displays all the Candidates who have applied to 1 Position. I would like to
include on this subform a searable list box with all the Candidates (not just
those related to the position). How can I do this? Any search I've been able
to put into the form, only searches the attached Candidates.

Thanks!

--
Message posted via http://www.accessmonster.com