Unbound field results are different then Query w/the same criteria

  • Thread starter Thread starter drdunit
  • Start date Start date
D

drdunit

I have a good understanding of relational databases, and have created
hand full, but it's not what I do full time and I am seriously lackin
in the terms and definitions dept.

First some back ground>>
Trying to create an Training Evaluation DB, in which there will be
front ends; an eval front end, and an admin front end. One of th
functions of the admin FE will be to use the "Questions Selection Form
and Enter/Select the questions that will be displayed on the eval F
automatically when it is opened...

In the BE 2 of the tables are Question_List and Questions.
Questions_List (QL) is mainly one field for all questions, Question
(Q) has 25 question fields per record. The admin user select
questions from the QL table and assigns a question to each field in th
Q table OR Enters a new Question which is saved as a new record into Q
and fills a field in Q.

In the Eval FE I have a form based on a query with both QL and
NON-Related. There is an Unbound field for each Question, which shoul
be populated by the Q table.

SELECT [tbl_Questions]![Q1] AS Q_1
FROM tbl_Questions
WHERE (((tbl_Questions.Q_ID)=1));

I have used this line in a query and it works, but when I try the sam
thing in the unbound field I get the FAMOUS "?NAME"
I've also tried using that line in the query that the Form is base
on... IT works when I run the query... not on the form...

I would appreciate any advice???
Thanks:confused
 
"Unbound field" makes no sense to me. Do you mean "unbound textbox"? If
so, where are you putting your SELECT statement? To get a value from a
table into an unbound control you'd normally use a DLookup() expression.

But I don't understand your data structure either. What's the purpose of
the "25 question fields" in the Questions table? By the sound of it you
need a structrure more like this, with a many-to-many relationship
between Questions and the surveys or tests or evaluations in which they
are administered:

tblQuestions
QuestionID
QuestionText
other stuff

tblSurveys
SurveyID
SurveyName
CourseID
other stuff

tblSurveysQuestions
QuestionID
SurveyID

I have a good understanding of relational databases, and have created a
hand full, but it's not what I do full time and I am seriously lacking
in the terms and definitions dept.

First some back ground>>
Trying to create an Training Evaluation DB, in which there will be 2
front ends; an eval front end, and an admin front end. One of the
functions of the admin FE will be to use the "Questions Selection Form"
and Enter/Select the questions that will be displayed on the eval FE
automatically when it is opened...

In the BE 2 of the tables are Question_List and Questions.
Questions_List (QL) is mainly one field for all questions, Questions
(Q) has 25 question fields per record. The admin user selects
questions from the QL table and assigns a question to each field in the
Q table OR Enters a new Question which is saved as a new record into QL
and fills a field in Q.

In the Eval FE I have a form based on a query with both QL and Q
NON-Related. There is an Unbound field for each Question, which should
be populated by the Q table.

SELECT [tbl_Questions]![Q1] AS Q_1
FROM tbl_Questions
WHERE (((tbl_Questions.Q_ID)=1));

I have used this line in a query and it works, but when I try the same
thing in the unbound field I get the FAMOUS "?NAME"
I've also tried using that line in the query that the Form is based
on... IT works when I run the query... not on the form...

I would appreciate any advice???
Thanks:confused:
Click to expand...
 
Yes I do mean "unbound textbox". DLookup() is something that crossed m
mind, but have not yet tried, I will give that a try...

The data structure; tblQuestions, contains 25 question fields, (thi
tbl name could have been Survey, Questionnaire) it's purpose is t
supply the specific Form with the questions that have been activate
for that Form. The tblQuestion_list tbl is a container to hold al
quetions that can be selected (my attempt to make this point-and-clic
user friendly, and allow reuse of questions without retyping)

The many-to-many relationship you described is what would be use
between Questions and Answers, but now that I have seen this on paper
THAT is another idea I will look more closely at... Another one of m
weaknesses, 98% of what I do is off the cuff, without clear plans...

Thank yo
 
Back
Top