Allen Browne's ConcatRelated() Function

[DoveArrow]

I have two tables:

tblApplication
tblApplicationProgramCurrent

In the first table is a field called ApplicationID. This corresponds
to a field in the second table (one-to-many).

I've tried running a query off of the two tables, and one using just
tblApplicationProgramCurrent. In each case, I get the same error
message:

"Undefined function 'ConcatRelated' in expression."

Now my database seems to recognize the function, because as I try to
enter data into each of the areas, the computer pops up with little
menus of the different tables and fields in my database. However I
can't get it to do anything other than frustrate me.

Here are some of the variations I've tried using the ConcatRelated
function. I don't know if this list is exhaustive, (I've been trying
various configurations for about an hour), but I'm hoping it will
provide some insight.

ConcatRelated("Program","jtblApplicationProgramCurrent","ApplicationID="
& [ApplicationID])
ConcatRelated("Program","jtblApplicationProgramCurrent","[ApplicationID]="
& [ApplicationID])
ConcatRelated([Program],[jtblApplicationProgramCurrent],
[ApplicationID]=" & [ApplicationID])
ConcatRelated([Program],[jtblApplicationProgramCurrent],
[ApplicationID]="'" & [ApplicationID] & "'")

Now it's quite possible that I simply don't understand how to use the
ConcatRelated function. That said, I've looked through some of the
common problems people seem to have with this thing. So far, I've
compiled my database, compacted it, rebooted my computer... nothing.
Help me Obi Wan Somebody. You're my only hope!

 

[John W. Vinson]

I have two tables:

tblApplication
tblApplicationProgramCurrent

In the first table is a field called ApplicationID. This corresponds
to a field in the second table (one-to-many).

I've tried running a query off of the two tables, and one using just
tblApplicationProgramCurrent. In each case, I get the same error
message:

"Undefined function 'ConcatRelated' in expression."

Where did you put the VBA code for the function? I'm GUESSING that you have it
in a module which is also named ConcatRelated. If so, you'll get this error -
you can't use the same name for a module and a program within that module. Try
changing the name of the Module to (say) basConcatRelated.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[DoveArrow]

:-0
:-|
X-0

See that's why I love coming here. You people always figure out what
ID10T error I've made this time. Thanks so much. It's working
brilliantly now.