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