Export data from a filtered subform

[dgaller]

I have a form with a subform that filters based on my selections.

For example I can select
a vendor ,
a status
and task type and my subform shows me my records as I filter.

Is there a way I can export what I just filtered to Excel?

 

[JBurlison]

no, you cannot export filterd data, you have to make your subform a query

Add the items you want from your table then in the blank Rows Put a expression in the field row,

[Your Field name in the query]=[Forms]![Your Form Name]![Control on form] Or [Forms]![Your Form Name]![Control on form] Is Null

once you do this uncheck "show"

Then under criteria put the word "True"


then on your dropdown boxes (as your contron on the form) select Proprerties
and on update have it requery the query.

Then you can export the query to excel.

 

[dgaller]

Thanks! I tried this and it worked.