I'm just learning about DLookup and I'm stuck. I'm wanting the txtAddress field to auto-populate dependent upon what is chosen from a combo box cboVendor. I've setup the DLookup as far as I know, but how do I then bind that result to the text box?

Code:
dim selVendorAddress as String
selVendorAddress = DLookup("[ADDRESS]", "VENDOR", "[cboVendor]='" & [cboVendor] & "'")
I would assume just slapping in this would work,
Code:
txtAddress.value = selVendorAddress
but that doesn't work. Help!