extracting data from form fields

[Guest]

i have a form which displays the details of a job. the fields it display are
[job no], [customer name] & [job details]. only one job is ever displayed on
the form at any one time.

i need a button on the form that opens another form and automatically
searches for the record with the same job number as that displayed on the
original form. basically i need a macro that extracts the job number from the
field [job no], opens a new form and searches for that job number in the new
form.

if you can understand what i mean please help.

Thanks Chris

 

[Guest]

Put something like this in the Click event of the button you want to open the
other form. Change the names I use to suit your environment:

DoCmd.OpenForm "MyOtherForm", , ,"[job no] = '" & Me.JobNo & "'"