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

Subform repeating query results.

P: 4
Hello thescripts and well met.

I've recently been handed a new duty and have the joy of 'crash coursing' MS Access.

Things are working well but I've ran into a problem that I can't seem to find an answer to anywhere.

I have a main form that contains a subform(datasheet view) based on a simple query with one criteria prompt. It's returning the data just as I need it to, but once it lists the results of the query in the sub-form (say three records were returned) then it lists those same three again and again and again.

How can I supress the endless query results in the subform and just have it stop after the results are listed the first time.

I hope this question makes sense and I thank anyone in advance for some insight.

Kind Regards,

Aaron
Asymmetric Warfare Division
US Army
Jan 23 '08 #1
Share this Question
Share on Google+
1 Reply


P: 4
Hello thescripts and well met.

I've recently been handed a new duty and have the joy of 'crash coursing' MS Access.

Things are working well but I've ran into a problem that I can't seem to find an answer to anywhere.

I have a main form that contains a subform(datasheet view) based on a simple query with one criteria prompt. It's returning the data just as I need it to, but once it lists the results of the query in the sub-form (say three records were returned) then it lists those same three again and again and again.

How can I supress the endless query results in the subform and just have it stop after the results are listed the first time.

I hope this question makes sense and I thank anyone in advance for some insight.

Kind Regards,

Aaron
Asymmetric Warfare Division
US Army
Hmm I deleted and recreated it and the results stop after the correct number of records return.

Strange, please disregard this question and I'm sorry to have bothered anyone with this...

/scratches head

Best!
-Aaron
Jan 23 '08 #2

Post your reply

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