Populate Combo Box selection to field

  • Thread starter Thread starter DJ Notion via AccessMonster.com
  • Start date Start date
D

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.
 
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
 
Thanks Jeff. Worked like a charm.


Jeff said:
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.
Click to expand...
[quoted text clipped - 4 lines]
Any help is apprecaited. Thanks.
Click to expand...
Click to expand...
 
Back
Top