Thankyou for helping me with my combo box query, however I am still having problems.<br><br>You said to set the Text Box source code as :-<br><br>=combobox1.culumns(2).value<br><br>however when I run the form the text box shows #NAME?, I therefore must be inputting incorrectly. Do I need to name the column as it appears ie<br><br>=[combo76.Company.value]<br>I have tried this but still does not work, howver I understand your logic - please once again help<br>