populate unbound field

[DCV0204]

I have a form named "File Request Form" containing an unbound text box named "Text19" and a form named "FileRequestedByForm" with a unbound combo box named "Staff". I am wanting staff to select their name on the "FileRequestedByForm" from the "Staff" combo box; when selected I would like the "File Request Form" to open with the "Text19" text box populated with the name selected from the "Staff" combo box.

[ssanfu]

I have a form named "File Request Form" containing an unbound text box named "Text19" and a form named "FileRequestedByForm" with a unbound combo box named "Staff". I am wanting staff to select their name on the "FileRequestedByForm" from the "Staff" combo box; when selected I would like the "File Request Form" to open with the "Text19" text box populated with the name selected from the "Staff" combo box.

Not quite sure what you want to happen. If I understand right:

Form "FileRequestedByForm" is open. Select a name from the combo box "Staff".

When the form "File Request Form" is opened, you want the staff name to be put in the text box "Text19"?
(You don't have a unique EmpID or an autonumber to use as a PK?)

How does form "File Request Form" get opened????

[DCV0204]

That is correct. I am wanting the staff combo box to populate the Text19 text box.
This database is only being used to email the request form it does not contain any tables except the one that list the staff for the combo box.
I created a macro that runs when the name is selected to open the second form "File Request Form".
Does the text box have to be bound for this to work?

[ssanfu]

That is correct. I am wanting the staff combo box to populate the Text19 text box.
This database is only being used to email the request form it does not contain any tables except the one that list the staff for the combo box.
I created a macro that runs when the name is selected to open the second form "File Request Form".
Does the text box have to be bound for this to work?

In the form "File Request Form", use the load event to get the name from the combo box in form "FileRequestedByForm"

Try this:

Private Sub Form_Load()

   Me.Text19= Forms!FileRequestedByForm.Staff

End Sub