Query Top Values

[dgunner71]

All,

[Note: This is a continuation of Discussion 955851 - RecordSet Type: Snap Shot View]

I have run into a scenario on search forms when using the "Top Values" property in the Record Source Query. I'm sure I'm just doing something wrong.

Scenario:

Parent Form houses search criteria fields - No Record Source.
Child Form is set to continuous and is bound to a query (I use a subform for design reasons). The query field criteria are then linked to the parent form fields.

Problem:

I'd like to use the 'Top 100 Values' in the query properties. When I first open my search form, this works great - results are limited to only 100. However, when I update my search criteria (i.e. adding "Smith" to the last name), the search will only find "Smiths" in the top 100 results.

I assume that I should separate this into 2 queries. The primary to filter and the secondary to limit the results to 100.

Thanks for your insight.

Gunner

[jimatqsi]

Gunner,
What do you mean by "when I update my search criteria?" What are you doing with whatever new search parameters you get?

If you filter you can only reduce the viewable rows but the recordset behind the form remains the same. If you actually change the recordsource of the form using the new information that should work.

Jim

[dgunner71]

Jimatqsi,

After typing a big long response, I now see that I am indeed using a filter for some reason. This is surely causing my dilemma.

Thank you for your guidance!

Kind regards and have a great weekend.

Gunner

[jimatqsi]

Glad to be of some help. :) Same to you, nice weekend.