Need to list history of Job Records linked only to the current Client Record being viewed

[Modify_inc]

I've created a form to manage my clients (ClientForm), and in this form, I created a text field to list only the jobs that are linked to the current client record being viewed. To accomplish this, I'm using a list box to display the job records via a query I created (qryClientJobs), and it appears to be working great, though with one serious flaw...the list is showing all jobs for every client, whether the job was assigned to the current client or not.

The tblClients and tblJobs have a 1 to many relation. I created a query to query the jobs, but apparently, I don't know how to tell the query to only find and display the jobs that are linked to the current client record being viewed. Is there a function or expression that I can use to filter the job IDs, like if jobID equals current clientID then display Job?



I've been out of the database scene for a while now, though thankfully a few things have come back to me, unfortunately, this is not one of them. Looking forward to any suggestions!

Mike

[pbaldy]

The listbox could be based on a query that uses the form in the criteria. You'd requery the listbox in the current event so it changed when you changed clients.

[pbaldy]

By the way, a subform would automatically sync with the main form via master/child links.

[Modify_inc]

By the way, a subform would automatically sync with the main form via master/child links.

I had forgot about subforms. I will definitely give it a try.

[Modify_inc]

The listbox could be based on a query that uses the form in the criteria. You'd requery the listbox in the current event so it changed when you changed clients.

I'm not sure I understand exactly what you're saying here, but I will attempt to figure it out if I don't have any luck with the subforms you mentioned.

[pbaldy]

No problem, post back if you get stuck.