i have a drop down combo box field in a form, when surveyorname is not in list there is a prompt to fill in other fields in a form surveyorcomp and surveyoradd. when a command button is clicked i want it to create a multi-colomn entry to a field.

using vba code how do i make

suveyornew = surveyorname(colomn 0) surveyorcomp(colomn 1) surveyoradd (colomn 2)

i hope this makes sense, i apologise if it doesnt, my brain has come to sleep today, lol