Hi,
I have a job list form with basic info on it. I want to be able to click on
the job number text box which then opens up a more detailed form and applies
a filter so that I only get the record for the job number that I have clicked
on from the underlaying form.

Could someone please tell me how to do this as I am guessing it should be
fairly simple although I can't figure it out.

Thanks in advance