I am using combo1 to filter combo2. I have used this technique elsewhere and got it working but I'm having trouble, maybe someone could suggest something.
I have a SELECT DISTINCT statement in combo2,
which refers to combo1 for it's criterea, using [Forms]![frmMyform]![cboBox1]. If I take out the [Forms]![frmMyform]![cboBox1] statement and type in a selection the filter works fine, but it just won't work when I try to refer to it using the [Forms]![frm etc.
I have checked the syntax and names on the combo boxes. Any ideas would be gratefully received.
Thanks in advance.
Russ
I have a SELECT DISTINCT statement in combo2,
which refers to combo1 for it's criterea, using [Forms]![frmMyform]![cboBox1]. If I take out the [Forms]![frmMyform]![cboBox1] statement and type in a selection the filter works fine, but it just won't work when I try to refer to it using the [Forms]![frm etc.
I have checked the syntax and names on the combo boxes. Any ideas would be gratefully received.
Thanks in advance.
Russ