COmbo Box with text box

[liiza]

I have a table that has First Name and Last Name and cost perday. I have
created a combo box that hast Last Name, First Name to combine the two and i
can pick anyone i want. Then i have a text box where i want the cost perday
to show up for whatever name i choose in the combo box. I've tried all the
instructions here, but none have quite got me where i can display the right
cost per day for each person.

Any help would be much appreciated.

 

[Tom van Stiphout]

On Fri, 30 Jan 2009 13:19:01 -0800, liiza

Change your combobox and have it display all three columns.
Then in your textbox write:
=myCombobox.Columns(2)
(of course you replace myObjectNames with yours)
Once it all works you can set the DisplayWidths of the combobox and
hide the third column.

-Tom.
Microsoft Access MVP