Auto Populate Text Box from Combo Box Selection

[indygirl]

I have been trying to auto populate a text box based on a user selection from the combo box in the same form. I changed the control source of the text box to reflect:

=me.Company.column(1)

And my row source for Company is:

SELECT Customers.Company, Customers.First, Customers.Last, Customers.ID FROM Customers ORDER BY Customers.Company;

My Combo Box is Company
My Text Box is First

My combo box seems to work fine but the text box doesn't populate. Can someone tell me what is wrong?

 

[PHV]

In the AfterUpdate event procedure of Company:
Me!First.Requery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886