help limiting return on query

alliandrina

Registered User.
Local time
Yesterday, 17:19
Joined
Mar 9, 2011
Messages
13
Since the last time i posted, I've decided to try something with the database work. I downloaded a survey database that someone posted for use and I'm trying to adapt it the work i have. So far the biggest hurdle is the form. It is based on a query, i think which set up the basic controls. A couple other fields have queries as control sources and those i think actually populate the form when loaded. The issue comes when i attempted to as another survey. The first survey will call up all the questions from both surveys. I've tried adding a where statement to the end of the queries that should limit it to a specific questions. In those the questions will be limited, but something will remain. On o one form i have an empty text box which i still have to fill. On another form, after finishing the last question, i get an empty list box and i can't move because i can't select anything? Any advice?
 
I forgot to mention there is a form with a button that called up the survey. I added a combo box and on the main query for the survey form a statement that would direct it to look at the combo box. Now, it kinda work. Save for the fact that when i added in more surveys and other info into the tables. Now each question is tripling so now to move on i have to answer the same question three times. Why would that happen?
 

Users who are viewing this thread

Back
Top Bottom