ComboBox lookup on SubForm

[Guest]

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

 

[Guest]

Try:
SELECT tblConComlkup.txtConComDocTitle FROM tblConComlkup WHERE

(((tblConComlkup.txtConComDoc)=Me!txtConComDoc));

I take it you are setting the Rowsource for the second combo in the
AfterUpdate event of the first? Since they are on the same form, you can just
use 'Me'.