Hi Dave,
That's strange, the way I suggested works for me.
Gavin...
>Hi Gavin, I still have the form function - that didn't work, so I tried the procs function, but eval() worked as Al suggested. Now I'll retry the form function with and without the evaluate.
>Regards
>Dave
>
>>Hi Dave,
>>
>>How about:
>>
>>
>>ThisForm.MyGrid.MyColumn.ControlSource = "ThisForm.MyFunction(mytable.fieldname)"
>>
>>
>>Hope this helps,
>>Gavin...
>>
>>>Yikes, I've asked this before; but how do I make one column in a grid, which is otherwise bound to a table show the value of a user defined function,
>>>eg grid.controlsource= myfunction(mytable.fieldname)
>>>I can't seem to make it work, it either falls over or shows a value from the grid recordsource from the nth attribute of the table, n being the column number.