A
Andrew Davis
First post! WooHoo!
I'm working on a DB that stores questions, answer sets,
and individual answers within sets. There is much, much
more to this scenario, but I'll list what I think is the
essential information.
I'm trying to create a form that allows a user to:
a) enter the name of the question (tables!questions.item)
b) enter the number of variables (tables!
questions.variables)
c) trigger a macro that, given the item name and # of
variables, creates
standardized blank answer sets in an "Answer"
table.
d) offer a list of variable choices for the user to
select (query!list_answer_set)
e) based on the answer set selected, the user can use the
text boxes on the page to
input the desired answer choices for that answer
set.
On items a-d, I'm doing ok. E is where my problems are
coming up. For item d above, I am using a combo box that
lists the answer sets created in item c. Item d writes
to tables!answers.answerset with the user's choice of
answer set.
Item e needs to pull the current value from tables!
answers.answerchoice, where tables!answers.answerset =
forms!Question_edit.combo(x) ("x" being the order of
answers in the question, in cases where more than one
answer set is used simultaneously).
I can seem to access that value with a select query
(Query!AnswerCode(x)), but I am unsure what to set as
the "control source" for the text box. I've been stumped
on this one. Can anyone help me with what I need to set
in "control source" here?
I'm working on a DB that stores questions, answer sets,
and individual answers within sets. There is much, much
more to this scenario, but I'll list what I think is the
essential information.
I'm trying to create a form that allows a user to:
a) enter the name of the question (tables!questions.item)
b) enter the number of variables (tables!
questions.variables)
c) trigger a macro that, given the item name and # of
variables, creates
standardized blank answer sets in an "Answer"
table.
d) offer a list of variable choices for the user to
select (query!list_answer_set)
e) based on the answer set selected, the user can use the
text boxes on the page to
input the desired answer choices for that answer
set.
On items a-d, I'm doing ok. E is where my problems are
coming up. For item d above, I am using a combo box that
lists the answer sets created in item c. Item d writes
to tables!answers.answerset with the user's choice of
answer set.
Item e needs to pull the current value from tables!
answers.answerchoice, where tables!answers.answerset =
forms!Question_edit.combo(x) ("x" being the order of
answers in the question, in cases where more than one
answer set is used simultaneously).
I can seem to access that value with a select query
(Query!AnswerCode(x)), but I am unsure what to set as
the "control source" for the text box. I've been stumped
on this one. Can anyone help me with what I need to set
in "control source" here?