Using Allen Browne's ConcatRelated() function but getting error

[davegri]

And as I suspected, the function needs to know to look at the form for the argument.
Combining WGM's fix for null, do it this way to get rid of the 3075 error:


=ConcatRelated("[Hive_ID]","[T_Hive_Inspection_Detail]","[Link_to_Log_Inspection_ID] = " & Nz([Forms]![F_Log_Inspection_Main].[Log_Inspection_ID],0),"[Hive_ID]",Chr(13)+Chr(10))

[Welshgasman]

Dave, the argument gets passed in OK?

[ScubaBart]

=ConcatRelated("[Hive_ID]","[T_Hive_Inspection_Detail]","[Link_to_Log_Inspection_ID] = " & Nz([Forms]![F_Log_Inspection_Main].[Log_Inspection_ID],0),"[Hive_ID]",Chr(13)+Chr(10))

It was able to work without adding the full form syntax, the error no longer shows up. Will keep this in mind for similar circumstances though.

[Welshgasman]

Yes, however I would generally allow the forms to do everything, but a Delete.
If it was VBA you could test for Me.NewRecord, but as an expression, that is not possible I believe.

You could alter the function to take that into account by passing in the frm object as well and test in there?

Nothing to say a good function cannot have enhancements as long as it works in all situations.

[moke123]

Get rid of the table level lookup fields!!!!

You can not name the module the same as the procedure.

this works

Edit: oops I see gasman found that already.

[davegri]

Dave, the argument gets passed in OK?

Yes, I had to do it that way to get rid of the 3075.