I have a form that uses fields from a query. The query has a paramter prompt that asks for a job number. The form has a control button that lauches another form (form #2). Form2 reads data from a second query that also has a parameter prompt. The parameter promt asks for the job number a 2nd time.
Is there a way to pass the results of the 1st parameter prompt to the 2nd query?