If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search all table records from filtered form
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 |
Thread Tools | |
Display Modes | |
|
|