R
ridgerunner
I have a form set up with the following as the Record Source:
SELECT DISTINCTROW tblDMInspecDet.*, tblQuestions.QstWithPtVal,
tblQuestions.QstID FROM tblDMInspecDet RIGHT JOIN tblQuestions ON
tblDMInspecDet.QstID=tblQuestions.QstID ORDER BY tblQuestions.QstSortOrd;
This works great to show the data entry person all of the Questions on the
form. The problem I am having is making another box for each question to
accept the tblQuestions.QstID as the data to be automatically entered into
tblDMInspecDet.QstID. I feel like I am so close to having this form set up
completed but I cannot figure out what I am doing wrong. I have tried to
pattern this after Duane Hookom's "At Your Survey" but I do not need to
create a survey, just a form that is similar to enter the data by connecting
the question and its ID to a new record containing the question ID and a
response. Seems simple, but I worked on this all afternoon and still no
good results.
Thanks,
ridgerunner
SELECT DISTINCTROW tblDMInspecDet.*, tblQuestions.QstWithPtVal,
tblQuestions.QstID FROM tblDMInspecDet RIGHT JOIN tblQuestions ON
tblDMInspecDet.QstID=tblQuestions.QstID ORDER BY tblQuestions.QstSortOrd;
This works great to show the data entry person all of the Questions on the
form. The problem I am having is making another box for each question to
accept the tblQuestions.QstID as the data to be automatically entered into
tblDMInspecDet.QstID. I feel like I am so close to having this form set up
completed but I cannot figure out what I am doing wrong. I have tried to
pattern this after Duane Hookom's "At Your Survey" but I do not need to
create a survey, just a form that is similar to enter the data by connecting
the question and its ID to a new record containing the question ID and a
response. Seems simple, but I worked on this all afternoon and still no
good results.
Thanks,
ridgerunner