Dim strWhere As String
strWhere = "[JobNumber] = " & Me.[JobNumber]
Debug.Print strWhere 'for testing only
DoCmd.OpenForm "NameOfForm", , , strWhere


Note:
If the job number field is a number data type, the code above will work.
If the job number field is a text data type, use this instead:
strWhere = "[JobNumber] = """ & Me.[JobNumber] & """"
Replace [JobNumber] with the name of the job number field

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Phil H" wrote in message
...
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