VBA code to export data from a subform to a text file

[shandoo27]

I would like to export the bounded data in a subform ( this subform is only bounded to a particular set of fields in the table) to a text file on the click of a button . Could someone help me with a suitable VBA code pls ?

 

[Freshman]

Not sure if I understand you correctly, but you could try this:

Behind the On Click event of the command button, you need to set the value of the chosen textbox to the value of the remote form.

me.textbox1 = Forms!NameofSubForm!NameofField

You could also possibly get the data straight from the bound table using sql or DLookup.