MS Access: Referencing fields from other records within each record

[leftengine]

I have a database of program block names and their descriptions. Each program block has inputs from other program blocks within the same database. I'd like each record to have the descriptions of the input programs descriptions in addition to the description of the block itself. Thus far I have set up a query which takes the input block names and concatenates them for formatting purposes. These names match the original table records. I set up another query which establishes a relationship between the concatenated names and the original table names, and then pulls the descriptions appropriate to those names. Here's the kicker--it works momentarily. After returning the proper results, a second later a dialog pops up saying "Invalid Procedure Call", and the query results turn into "NAME?" error messages. What does this mean, and how can I get my results to stay..I'm so close.

 

[WaltLukeIII]

I think that Somewhere you have an illegal procedure name or call meaning you probably miss spelled a name or forgot a parameter may forgot to return something.
It does sound like your very close. Try putting msgbox "here I am " into your code and see how far you get start it somewhere in the middle if it shows up move it farther into your code if it doesn't show up move it backward in your code. Good hunting,

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl