Paul, You can set the recordsource up to be =User_Defined_Function(vParameter)
And in the UDF you can retrieve and return any value you need. In your case you could pass the Grid recordsource for the grid I guess. Is this what you mean? Dave Crozier And in the Function -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 07 June 2007 10:21 To: profox@leafe.com Subject: Faking it - ControlSource Hi all I have a grid and in one column I need to put a control which does not have a native controlsource property. The column needs to have have sparse set to .F. and each row in this column should have a display/value dictated by a value from a table whci is the recordsource for the grid. The simplest example might be that the control is a label and I need its caption to be "bound" to the recordsource. Another example might be a container whose contained objects need to have properties bound to the recordsource. A third example might (?) be an ActiveX control (NOT oleBound) that I want to behave like an olebound control - although I don't need this right now. Can something like this be done ? Thanks Paul Newton [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.