Performace Issue with bound form

[hpl2001]

Hello:

I have a form that is bound to a query, and it is opening extremely slowly. The first thing the form does is collect some info that is used to narrow the query. How can I set things up so the the form does not try to bring down data until the my search button is pressed (at which point the data is filtered and the dataset should be very small). I'm guessing at the moment the form is trying to download all the unfiltered data, and this is currently taking many minutes.

Thanks.

Holly

 

[dhookom]

You need to provide information about the record source of the form and how you are filtering the records. I expect you could provide a default filter which you can change as needed.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya hpl2001 . . .

Typically what you need to do in this case is remove (delete) what ever is in the forms [blue]RecordSource[/blue]. This forces the form to open with no data. Then when you hit your button you construct an SQL with criteria and write it to the [blue]RecordSource[/blue] ... and voila ... its done!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

hpl2001 . . .

Can you share the [blue]SQL[/blue] of the query along with the [blue]control and data types[/blue] of the items collected with the form? ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]