Help Understanding "SELECT" In Record Source

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

The problem is that by using DISTINCTROW, you have eliminated
duplicates, but you have created a recordset that cannot be updated.

Ideally, each form/subform should be based on just one table. For more
information, download and read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
(: have an awesome day
*


ridgerunner wrote:
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

I will download and read the file, but now I am really confused, since I
thought I needed to use 'At Your Survey' as a model for my inspection form.

"strive4peace" wrote:

The problem is that by using DISTINCTROW, you have eliminated
duplicates, but you have created a recordset that cannot be updated.

Ideally, each form/subform should be based on just one table. For more
information, download and read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
(: have an awesome day
*


ridgerunner wrote:
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