Combo box controlling text box 4

[Crystalguru]

This must be posted somewhere, but I cannot find it...
I would like my users to select from a combo box an associate's name (asc_lastname,asc_firstname). When the selection is made I would like the Unique Identifier(asc_uid in the Asc_profile table) for that associate to populate a text box. Then the user will click on a button to run a report that is linked to the asc_uid. I just cannot get the associate's name to control a text box! The user will not be able to modify these fields just choosing for a report.

Spent all morning on this little thing....

 

[WildHare]

The record source for your combo box should include the ID field. You don't have to show it, just include it. Set it's WIDTH in the combo box property sheet to zero. (depending on whether it's column 1 or column 3, physically:

ColumnWidths: 0;1.5;1.5
or
ColumnWidths: 1.5;1.5;0

Then you can refer to it in the combo box's AFTER UPDATE processing by using it's column number. (Don't forget that combo box column numbers are zero based for this process.)
For example,

Sub MyCombo_AFTERUPDATE()
...
...
Me.AssociateID = Me.MyCombo.column(0)
...

Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com

 

[Crystalguru]

Jim
Here's the sql;
select name, asc_uid from asc_profile

I added the code:
Sub Combo0_AFTERUPDATE()
Me.textbox8 = Me.Combo0.column(2)
end sub

When I go to the combo box and select an associates name (last,first) then tab to the text box, nothing happens.. What did I forget to do?

Thanks,
crystalguru

 

[WildHare]

Remember when I said:
...column number. (Don't forget that combo box column numbers are zero based for this process.)...


As written, your combo has NAME as Column(0) and ASC_UID as column(1)

Try this:

Sub Combo0_AFTERUPDATE()
    Me.textbox8 = Me.Combo0.column(

1

)
end sub

Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com

 

[Crystalguru]

Ah ha! I guess if I would of read your directions the first time, I would of got it.

Works great!

thank you for your time!
crystalguru.