Inputting an Form value into another Form

[Data69]

I have a form that allows me to insert a Problem # (P0000000). I have this form query a table to see if this record already exists. If the form doesn't exist I would like to have the inputted problem number applied to another form that will then pull data from an external database. How do I apply the unbound text from the first form into the second form?

 

[coco86]

You could do something like this:

docmd.open "form2"

forms!form2.[field] = me.[field]

This will only work if form2 is not embedded in another form

 

[Data69]

That works. Thanks