Combo Filter problem (1 Viewer)

[RussG]

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

 

[Pat Hartman]

Three possibilities come to mind:
1. you don't have a requery for the second combo box in the AfterUpdate event of the first combo box
2. a typo in the form control name in the query
3. the control is on a sub form in which case the reference is incorrect. It would be [Forms]![frmMyform]![frmSubForm].[Form]![cboBox1]

 

[RussG]

I've nailed this now, I had an incorrect bound column setting. Thanks for your help anyway - I will be using a subform next so your reply will come in handy.

Thanks again

Russ