This is causing my some grief :)
I have a form that displays records in a tabular format, one field is a combo box that displays values from another table. But I only want some of those values to be displayed based on another field on my form. So as I go to the next record I want the values in the combo box that I select to change.
I did a query based on the field value and then in the combo box entry event I did a requery and it worked great for restricting my fields but it hosed all the other records.
So lets say record 1 Area=1 I want values A,B,C and record 2 Area=2 I want values D,E,F. I go to record 1, click the combo box and A,B,C show up in my list I select "A"
Then when I went to record 2, click on the combo box, D,E,F show up fine but when I select D, the field in record 1 goes blank because its value is no longer in my list.
I think I'm almost there just missing one detail.