Exporting Certain Records to Excel

  • Thread starter Thread starter Confused
  • Start date Start date
C

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?
 
The query you use to do the export has to be filtered based on control where
the customer is identified on your main form.
 
Do you know how to export the current record?

Klatuu said:
The query you use to do the export has to be filtered based on control where
the customer is identified on your main form.
Click to expand...
 
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.
 
Back
Top