473,394 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Subform repeating query results.

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
1 1836
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

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

Similar topics

13
by: Wescotte | last post by:
Here is a small sample program I wrote in PHP (running off Apache 1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data base is using DB2 V5R3M0. The client is WinXP machine using...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
1
by: teddyparnell | last post by:
I have a query that works, but then displays the results in a datasheet view. The query is reliant on the results of a combo box, and when i update this combo box and click a button the results of...
2
by: Smartin | last post by:
Using Access 97 I am trying to create a form that allows for user entry of search terms and displays a table of results. I thought I could accomplish this using a subform but it isn't quite...
14
by: Kurt | last post by:
I have an unbound main form with an unbound subform. frmProjects fsubProjectList Using combo boxes, the user can select several search criteria on frmProjects and then click a command button....
1
by: lawton | last post by:
Source: this is an access 2003 question My knowledge level: reading books, internet, and trial & error; no formal training I'm trying to get a running sum of what's filtered in a subform which is...
3
by: Flo100 | last post by:
I have a subform that i created in a main form, which I am using to display results of a query. There are different controls on the main form that make a query. The subform, so has to display the...
1
by: Flo100 | last post by:
I have a subform on a main form. I want the subform to display result from a saved query "qryMain" on button click event. Now in another button click event I modify the definition of qryMain. I...
16
by: dougmeece | last post by:
Good day everyone, I have a database with 2 main forms. The first form is used to add records to the database and contains a command button that opens the 2nd form for records searching. On...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.