asked on
SQL statment in subform doesn't work when running from Parent form
Experts, here is a quick SQL Statement syntax question.
I have a subform called frmResponses.
I have a button with an OnClick event that runs the following SQL statment.
sSQL = "DELETE * FROM QSTNRT_SELECTION_PROB WHERE [QSTNRT_SELECTION_PROB_PID
It works correctly when I run it directly from frmResponses.
frmResponses is a subfrom on frmTree2 (the parent from).
When I access it through the parent form, frmTree2, I get prompted for...
Forms![frmResponses]![Prob
Access doesn't recognize it...
I've tried numerous things such as:
Forms![frmTree2]![frmRespo
Forms.[frmTree2].[frmRespo
Forms![FrmTree2]![ProbSelP
Any ideas?
Thanks in advance...
-dsg
I have a subform called frmResponses.
I have a button with an OnClick event that runs the following SQL statment.
sSQL = "DELETE * FROM QSTNRT_SELECTION_PROB WHERE [QSTNRT_SELECTION_PROB_PID
It works correctly when I run it directly from frmResponses.
frmResponses is a subfrom on frmTree2 (the parent from).
When I access it through the parent form, frmTree2, I get prompted for...
Forms![frmResponses]![Prob
Access doesn't recognize it...
I've tried numerous things such as:
Forms![frmTree2]![frmRespo
Forms.[frmTree2].[frmRespo
Forms![FrmTree2]![ProbSelP
Any ideas?
Thanks in advance...
-dsg
Microsoft AccessSQL
Last Comment
dsg138
ASKER
Thanks for the quick reply Jim...
I now get Method or Data Member not found.
I now get Method or Data Member not found.
ASKER
Raised the pts some, if there are any other suggestions... Thanks!
ASKER
I'm still having some syntax issues with is.
The subform I'm refering to is a continuous subform and the button appears next to each record.
Do I really need to identify the parent form, being that it's all on the same line of the subform?
If anyone has some ideas, I'd really appreciate it.
-dsg
The subform I'm refering to is a continuous subform and the button appears next to each record.
Do I really need to identify the parent form, being that it's all on the same line of the subform?
If anyone has some ideas, I'd really appreciate it.
-dsg
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
sSQL = "DELETE * FROM QSTNRT_SELECTION_PROB WHERE [QSTNRT_SELECTION_PROB_PID