Question Accessing specific control-values (not recordset values) in a continuous subform

[whisp]

Hi all

A continuous subform contains a textbox control with relatively costly calculated data, using a function as control source. A button "copy to clipboard" on the mainform should copy the subform data to the clipboard, but i don't want to calculate the textbox content again, if possible, but instead just copy it from the textboxes.

Is there a way to loop through the subform's rows and access each row's textbox values from within the mainform's "copy to clipboard" button's on click event handler?

Thanks for any hints.

whisp

 

[Beetle]

If you're attempting to copy these values to the clipboard, then presumably you're ultimately trying to export the values to another program? If you can post back with more detail about what you're doing, there may be another way. For example, you may be able to place your function in a calculated query field, instead of an unbound calculated text box on a form, and just export the query results.

 

[whisp]

Hey Beetle

Thanks for your answer. I guess reading the values out of the controls is not possible then?

The copied text is for 'exporting' into a proprietary computer game that has a builtin notepad. It saves the user from alt-tabbing out of fullscreen in order to view that information.

But using the function in the query works perfect. Thanks!

whisp