dont use .VALUE.
if its a combo box beware of the BOUND COL.
if bound col = 1 and your field is [ID] is in col 1 then you will get 4.
you may want a different column cboBox.Column(2) to get the city. NOTE in vb code columns begin with zero, so cboBox.column(1) is actually column 2.
I cycle thru a combo (or listbox) to load the screen using the combo ID, then print/email using field on the form since the combo box loaded them.
when I choose combo item, it filters my record on the ID
Code:
sub cboBox_Afterupdate()
me.filter = "[id]=" & me.cboBox
me.filterOn = true
end sub
now my fields are: txtName, txtAddr, txtCity...etc