B
BrianPaul
I have on a subform a command button. Here is the Code
DoCmd.OpenQuery "QFactAdd", acViewNormal, acEdit
In the Query here is the Code
INSERT INTO TFacts ( Subject, Scripture, remarks )
SELECT TStudy.Subject, TStudyScriptures.Scripture, TStudyScriptures.remarks
FROM TStudy INNER JOIN TStudyScriptures ON TStudy.studyid =
TStudyScriptures.studyId
GROUP BY TStudy.Subject, TStudyScriptures.Scripture,
TStudyScriptures.remarks, TStudyScriptures.ScriptureId
HAVING (((TStudyScriptures.ScriptureId)=[forms]![study Edit]![Study Edit
Sub]![ScriptureID]));.
When I run the code, a Box comes up asking me for the scriptureid. If I
input the number it recognizes it and adds it to the new table. I am
assuming that it doesnt know the scriptureID and thats why its promting me
for it. What am I failing to do or not getting from this. Thanks any
responses greatly appreciated.
DoCmd.OpenQuery "QFactAdd", acViewNormal, acEdit
In the Query here is the Code
INSERT INTO TFacts ( Subject, Scripture, remarks )
SELECT TStudy.Subject, TStudyScriptures.Scripture, TStudyScriptures.remarks
FROM TStudy INNER JOIN TStudyScriptures ON TStudy.studyid =
TStudyScriptures.studyId
GROUP BY TStudy.Subject, TStudyScriptures.Scripture,
TStudyScriptures.remarks, TStudyScriptures.ScriptureId
HAVING (((TStudyScriptures.ScriptureId)=[forms]![study Edit]![Study Edit
Sub]![ScriptureID]));.
When I run the code, a Box comes up asking me for the scriptureid. If I
input the number it recognizes it and adds it to the new table. I am
assuming that it doesnt know the scriptureID and thats why its promting me
for it. What am I failing to do or not getting from this. Thanks any
responses greatly appreciated.