Please help me with this error....

[sabavno]

I have this string assigned to the variable in the query:

strFullName = Trim$([BlackBerryRecord].[LastName]) & ", " & [BlackBerryRecord].[FirstName]

It worked find, but all of the sudden started given me the error FUNCTION ISN'T AVAILABLE IN EXPRESSIONS IN QUERY EXPRESSION ' Trim$([BlackBerryRecord].[LastName]) & ", " & [BlackBerryRecord].[FirstName].'

Why did it work before and does not work now? What could have gone wrong with query?

Please help

Thanks

 

[cmmrfrds]

Maybe there is nulls in this field [BlackBerryRecord].[LastName]