By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

Query Top Values

100+
P: 110
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
Apr 3 '14 #1

✓ answered by 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

Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,240
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
Apr 3 '14 #2

100+
P: 110
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
Apr 4 '14 #3

Expert 100+
P: 1,240
Glad to be of some help. :) Same to you, nice weekend.
Apr 4 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.