Filtered split form exported into Excel

[jaryszek]

Hi,



I would like to create a split form with multi search textboxes in order to filter data on it.

After that i want to give user possibility to export filtered data into Excel sheet.
It is possible?

How can i do that?

Thank you for your help,

Best Wishes,
Jacek

[June7]

UNBOUND controls for entering filter criteria will work the same on a split form as on a regular form. The controls will show as fields in the datasheet part but they can be hidden.

Offering user option to export form dataset can be done by programmatically opening the import/export wizard: Docmd.RunCommand acCmdExportExcel

[jaryszek]

Thank you June7 !

It is ok.

I want to do split form with multisearch textboxes.
And now the most difficult problem: user will filter any data and after exporting my application has to change status (only with filtered data).

Status should be changed from "ended" to "exported".

How can we solve that?

Any suggestions?

Best wishes,
Jacek

[jaryszek]

I am closing the topic,
I will set up new one.

Thank you !