DlookUp Macro failing
This should work but doesn't and driving me nuts - not even sure where it's failing!!!
As I understand it, this code says...
I want the CustomerName field from the CustomersTable input to the CustomerName field on the active form and I want the CustomerName from the Entry in the CustomersTable that is in the record I just selected with the cboList box.
(I have it set to after Update on the cboList field)
DLookUp("CustomerName","CustomersTable","CustomerN ame = " & [cboList])
I know I'm missing some quotes or brackets or soemthing - I've tried a plethera of combinations - now show me the right choice!