Lookup simple problem

[colinmunnelly]

I think im missing something obvious here goes.
I have a table called 'names' within that table there is a field called 'Company' and a field called 'lineone'. On a form i have got a combo box that looks up the company field in the names table. I want a text box to populate the matching 'lineone' field.

I have enterd =dlookup("lineone","names","[combo44]")

I have not used this function for ages and have been trying to sort it myself but getting to annoyed with it now. Someone put me out of my misery!!!

Thanks all

 

[Rich]

You don't need DLookup, add the lineone field to the combo box row source's underlying query, assuming it becomes column2 in your combo then just set the text box control source to
=[MyCombo].[Column](1), where column 1 is the second column in your combo

 

[colinmunnelly]

Thanks but!!

Thanks Rich got it working but how do you add a second text box that picks up 'linetwo' data?