J
Jerry in the Desert.
I have a combobox based on the value selected in another combo box. On the
form it works fine, but when I add this sub form to the main form it doesn't
work. Here is the statement I have in the rowsource of the second combo box:
SELECT tblConComlkup.txtConComDocTitle FROM tblConComlkup WHERE
(((tblConComlkup.txtConComDoc)=Forms!frmCRMS!txtConComDoc));
When I place this form as a subform in frmMain, it prompts me for the value
of txtconComDoc. What is the syntax for this when it is executed from the
subform?
Thanks all
form it works fine, but when I add this sub form to the main form it doesn't
work. Here is the statement I have in the rowsource of the second combo box:
SELECT tblConComlkup.txtConComDocTitle FROM tblConComlkup WHERE
(((tblConComlkup.txtConComDoc)=Forms!frmCRMS!txtConComDoc));
When I place this form as a subform in frmMain, it prompts me for the value
of txtconComDoc. What is the syntax for this when it is executed from the
subform?
Thanks all