I have a parent-child relationship. The parent is changed by a spinner. When the parent changes, I change the filter on the child to have only records matching the parent. The child records are in a grid.

For some reason, when I change the parent, the grid stays the same!

It gets stranger...

To check to make sure the filter was getting set properly, I put a button on the form that browses the table. According to the browse, the filter is set right.

The weird thing is that after I browse the table, it starts working correctly. I can spin and spin and the grid updates.

It is the browse that's doing it. I tried having the button just select the table and commented out the browse and it didn't work.

What's so special about browsing that would make this start working? How do I get it to work without the browse?

Thanks,

Michelle