Exporting Certain Records to Excel

[Confused]

I have a form/subform arrangement Customers/Tasks. How do I export only the
current record I am working with( so I can show the tasks completed for only
that customer)?

Related Question:

Also I have Allen Browne's Search format set up on my forms, which filters
the information. How do I export only the records that are filtered to an
excel document?

 

[Klatuu]

The query you use to do the export has to be filtered based on control where
the customer is identified on your main form.

 

[Confused]

Do you know how to export the current record?

The query you use to do the export has to be filtered based on control where
the customer is identified on your main form.

 

[Klatuu]

create a query that included the data you want to export. Filter the query
on the control on your form that has the customer number and run the query
from a command button.