If you could help me with this problem I would be very very greatful.

I have a combo box on a form that is generated from a table with 2 colums:

1)Workstream
2)Manager

When you select a workstream from the combo box I would like a form field on the form to be populated with the manager that relates to the workstream chosen.

K, the workstream in the combobox is the first column and the manager is the second
right?

In that case, your form field should have the data source:

Form Field=[ComboBoxName].[Column](1)

Column(1) is the second column, Column(0) would be the first (workstream in this case)

Dunno if this is what you meant....

Yes thanks - that is what I mean

however I still cant get it to work. The box where I want the manager to appear, is just an unbound box. Am I write in putting the line you sent me in the control source for the box. I have done this and put in the combo name but it just leaves a blank space?

Thanks for your help!

Ha ha!

Solved it - thanks for your help I had forgotten to make the dropdown show both columns!

Cheers for your help!!!!!!!!