Finding record in subform

[TrekBiker]

I have a frmClients that shows clients' jobs in a subform, linked by ContactID.

Some contacts have large numbers of jobs. My client uses CTRL+F in the subform's JobID field to search for a particular job but says this can be very slow.

Is there an alternative, eg putting a finder combo in the subform? I've tried this with SQL source that I thought would limit JobIDs to the current contact but it doesn't update when moving to another contact.

SELECT qryJobs.JobID, qryJobs.ContactID
FROM qryJobs
WHERE (((qryJobs.ContactID)=[forms]![frmClients].[ContactID]))

Any suggestions much appreciated.

 

[TrekBiker]

Have moved on a stage with this, creating a copy of the jobs subform as a separate form and opening it from the original using a filter for the current ContactID.

Adding a search combo does the job but it's a bit inelegant. Any thoughts on doing the same direct from the original subform?

 

[MarvinM80]

TrekBiker,

I found the most help with searches/filters from Allen Browne.

http://allenbrowne.com/ser-62.html

Marvin M