The click event of your open button is a macro. (I NEVER use macros)
It looks like the macro command to open a form does not have the capability to have a parameter to pass values as an "OpenArgs".
If you converted the macro to code, it would look like
Code:
'------------------------------------------------------------
' Order_Entry_Click
'
'------------------------------------------------------------
Private Sub Order_Entry_Click()
On Error GoTo Order_Entry_Click_Err
DoCmd.OpenForm "Order_Form", acNormal, , , , , Me.Job_No 'OpenArgs parameter
Order_Entry_Click_Exit:
Exit Sub
Order_Entry_Click_Err:
MsgBox Err.Number & ": " & Err.Description & " (" & Erl & ")"
Resume Order_Entry_Click_Exit
End Sub
-------------------------------------------------------------------------------
Edit: just saw you have look up FIELDS in several tables.
Most experienced Access programmers DO NOT use Look up FIELDS.
See
The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm