I have a wierd error when im trying to run an update query on an access database here is the line where im having a problem
.QueryDefs("qryRecipeUPD").Parameters("[txtDirections]").Value = trim$(txtDirections)

i get an error that tells me an invalid use of property

i tried removing the trim$() and tried it again and it still wouldn't work

finally i tried just putting in a constant string "hi" and it worked.

When i look at the value of the query def paramater when im in debug mode it shows as empty which lead me to believe it was a variant. So i tried to do a cvar() and just a plain trim() and neither would work. Does anyone know what is going on?