Populate Combo Box selection to field

[DJ Notion via AccessMonster.com]

Hello.

I have a form with a combo box called username. The user selects their name,
enters a password, and clicks OK. Upon clicking OK, my second form opens.
On that second form I want to show the username selected in a field.

Any help is apprecaited. Thanks.

 

[Jeff Boyce]

One option would be to keep the password form open, but hide it. Then you
could refer to the username on that form in your second form with something
like:

=Forms!YourPasswordForm!cboYourUserName.Column(1)

in the Control Source of a textbox on that second form.

(NOTE: this assumes your combo box on form1 has UserID as the first field,
and UserName as the second)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DJ Notion via AccessMonster.com]

Thanks Jeff. Worked like a charm.

One option would be to keep the password form open, but hide it. Then you
could refer to the username on that form in your second form with something
like:

=Forms!YourPasswordForm!cboYourUserName.Column(1)

in the Control Source of a textbox on that second form.

(NOTE: this assumes your combo box on form1 has UserID as the first field,
and UserName as the second)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello.

[quoted text clipped - 4 lines]

Any help is apprecaited. Thanks.