Is there a way to copy or capture the data from a subform cell while in the parent form?  In other words while working in a form I want to be able to click on a cell in the subform and then click on a command button that would show a writeln window with the contents of that cell.  I was unsuccessful finding code for this. I’ve tried making a macro that would copy the contents of the cell but can't seem to make it work. I thought that if I could get the cell data to the clipboard I could use WriteLn(@GetSelectionContents()) to show me the contents.  The reason that I want to copy the cell data is so that I can use it in a search.

Any thoughts would be appreciated.  

Thanks Erika,

How do I get ClientLocalValue to recognize the cell in the subform that I click on?

Hi Erika,

The client wants to be able to click on an invoice number shown in a subform record which then would pull up that invoice.

You could use something like the following in the On Element Entry event for every LE (field) in the subform:
ClientLocalValue("SubformValue", ThisElement)

Then, put this in the command button's On Element Entry event in the parent form:
WriteLn( @ClientLocalValue("SubformValue") )

This will allow you to click on any cell in the subform, and then click on the command button to make the subform values display in the slate (WriteLn window).

tcgeo wrote on Jul 12^th, 2010 at 3:18pm:

Well, in that case you could modify my suggestion by putting the first portion in the subform's (not the field's) On Element Entry event, and change it to something like ClientLocalValue("SubformInvNo", InvNo).

Then the command button could grab that value, and fetch the desired record from there.

tcgeo wrote on Jul 12^th, 2010 at 4:11pm:

Not using it exactly like that, but it's part of a more complex function (which I may publish in Inside Sesame at some point).