export subform data to a text box or to a file

[Guest]

Hello All

I have here a problem that is:

I have a form called frmGames with a combo box called cmbGameType, so when i
change the value of my cmbGameType, a sub form called subfrmGames, based in a
query(qryGames) shows the correct data.

My question is, how to do a command button to export this data on my subform
to a textfile or to a text box?

Thanks

 

[Guest]

Use the TransferText command line, check help about the options you can have

docmd.TransferText acExportDelim,,"QueryName","c:\FileName.txt"

 

[Guest]

Hello Mr Ofer Cohen,

the tranfertext worked, but export all records that i have in the query, i
just want to export the record that are filtered in my form... is it possible
do to that?

 

[Guest]

How did you filter your query?

You can create reference in the query to the combo in the form

Select * From TableName Where FieldName = Forms![frmGames]![cmbGameType]

On the after update event of the combo run the code

Me.[enter here the Sub Form control name].Requery

 

[Guest]

Thanks for your prompt answer,

But still don't work....

Imagine that, in the combo box i chose the game type "Action", so the
subform with the list of the games, display the correct games, sorted by
pontuation(pontuation filed is not on my query). Who could i export?

I just want the list that is displayed on my subform(based on that query and
on that filter), and not all data in my query

Thanks again

How did you filter your query?

You can create reference in the query to the combo in the form

Select * From TableName Where FieldName = Forms![frmGames]![cmbGameType]

On the after update event of the combo run the code

Me.[enter here the Sub Form control name].Requery

--
Good Luck
BS"D

Hello Mr Ofer Cohen,

the tranfertext worked, but export all records that i have in the query, i
just want to export the record that are filtered in my form... is it possible
do to that?