F fredg Mar 11, 2004 #3 Sorry guess I hit send to soon.. I am getting and "Compile Error Sub or function not define" message. Here is what I'm trying to get to work. [thold1] = CONCATENATE([cbcustid], "*") Who do I define this? thold1 and cbcustid are both fields on my form. The help section didn't show me how to define this and I'm not much on VB, or even Access as far as that goes. Thanks Mark Click to expand... Mark, Concatenate is not an Access function. You really don't need it in Access anyway. In VBA: [thold1] =[cbcustid] & "*") Or .. as the control source of [thold1]: = [cbcustid] & "*"
Sorry guess I hit send to soon.. I am getting and "Compile Error Sub or function not define" message. Here is what I'm trying to get to work. [thold1] = CONCATENATE([cbcustid], "*") Who do I define this? thold1 and cbcustid are both fields on my form. The help section didn't show me how to define this and I'm not much on VB, or even Access as far as that goes. Thanks Mark Click to expand... Mark, Concatenate is not an Access function. You really don't need it in Access anyway. In VBA: [thold1] =[cbcustid] & "*") Or .. as the control source of [thold1]: = [cbcustid] & "*"
