Concatenating 2 fields!

[VS24]

Hi guys... newbie in the house!!

Straight to the point!

I have an Implementers table with Implementer types : "RCL", "RCM", "GB", "MP" etc.

I have a form that filters the Implementers table by restrictions "RCL" & "RCM".

Have a field called [RegImpID] (Text), another field called [Implementer ID] (Autonumber), a third field called [RegID] (Text).

Need to combine [Implementer ID] & [RegID] into [RegImpID].

This is the code I'm using :

[RegImpID].Value = Str([Implementer ID].Value) + [RegionID].Value

It's giving me the "Run-time error 2465" plus "Can't find the field '|' referred to in your expression"

What am I doing wrong?

I've done it to another form that doesn't filter on anything, but just goes through the entire table!
The code is identical (well except for the field names )... ) and that works fine... it combines them perfectly!


Thanks in advance!!

 

[earthandfire]

Roy, thanks for the explanation of the pipe. I've never come across that before. But I still can't work out how VS24's code works using the same syntax on the other form.