CONCATENATE

  • Thread starter Thread starter Guest
  • Start date Start date
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] & "*"
 
Back
Top