Update a unbound field on 1 form with data from another unbound field on another form

[spidge32]

I have a form which has a unbound field "JobSheetCombo". (This field is used to search for a Part Number. A button opens a form to print the data for the particular Part that is the value of the JobSheetCombo.
What I would like to do is load the value of the "JobSheetCombo" field to the unbound field "cboPN" on the opened form when the form is opened.
Currently I have to retype the Value of "JobSheetCombo" into the field "cboPN"

[davegri]

Try it with Openargs.

from the calling form:

DoCmd.OpenForm "MyTargetForm", , , , , , Me.JobSheetCombo

then in the called form's Form_Open event:

Me.cboPn = OpenArgs

[Micron]

If you're passing a value to a control on a form (if it's unbound I think it's a bit of a misnomer to call it a field) and using that combo to filter the form, why don't you just open the form filtered to that record or records?

[spidge32]

Davegri,

Thank you for your help, code works a treat.