T
tewald
In Access XP, I have a form with several comboboxes in the header; this
allows the form (in the data portion, of course) to imitate Excel's
AutoFilter capabilities. Now that Access 2007 has those abilities built-in,
I'd like to use them.
In my original form, as the user made choices from the comboboxes, I added
code to the Where clause of the underlying SQL code for the data portion of
the form. When the user had the dataset wanted, he/she would click a button
to export the data for use elsewhere. To do the export, I used the SQL code
that had been built. If I use Access 2007's native filtering capability, this
SQL code will not exist. How do I reference the filtered data from the form?
If this would be easier using a form and subform, please feel free to
suggest that. In either case, I'm unclear as to how to reference the filtered
data.
Thank you.
Tom Ewald, Detroit Area
allows the form (in the data portion, of course) to imitate Excel's
AutoFilter capabilities. Now that Access 2007 has those abilities built-in,
I'd like to use them.
In my original form, as the user made choices from the comboboxes, I added
code to the Where clause of the underlying SQL code for the data portion of
the form. When the user had the dataset wanted, he/she would click a button
to export the data for use elsewhere. To do the export, I used the SQL code
that had been built. If I use Access 2007's native filtering capability, this
SQL code will not exist. How do I reference the filtered data from the form?
If this would be easier using a form and subform, please feel free to
suggest that. In either case, I'm unclear as to how to reference the filtered
data.
Thank you.
Tom Ewald, Detroit Area