Hola Kenneth,

One trick I learned early on with access is that it chockes on complex queries.

I would suggest that you call the form from ANOTHER snippet of code that would take care of creating a temporary table with the records you need and base the form on that table.

At one point I had a form based on a very complicated query and when I used the above method, time went from about 3 minutes to 30-40 seconds.

Alex


>Is it possible in Access to set a filter on tables/queries in forms and reports, that is, not assign the filter to the form or report but to the data? I am trying to make a report with fields from 9 different queries-elections from different years-which I want filtered by state and town. I tried to create an SQL to pull out only the records needed but Access choked on the SQL statement ("SQL too complex" error or froze machine completely). Also, I have the formats for the individual elections on forms and it would be much easier if I could just cut and paste the controls onto a report (instead of having to rename the controlsource for each control).
>
>In VFP it would be a snap.
>
>Can you work directly with tables and queries in Access. Access help is no help at all (unless you like wizards).
>
>I know this isn't an Access usersgroup but I thought that someone might be able to give a quick answer and explain it to someone who is looking at it from a VFP perspective.
>
>TIA