I got it. I set the Grid.recordsource nothing. Then when the user selects a value I set the recordsource. However, I did not realize that you had to set the control source for the columns again.
It works at least, but if there is something different or a better way please let me know.
It works at least, but if there is something different or a better way please let me know.