I created a form where it takes all the field from a table and displays.
than I created a combobox on header of the form and fill distinct value from one of the field of that table.
I wrote a code in combobox change() property which opens a query (query has condition will display record which matches with the combobox)
Every thing works fine except when I select selection from combobox to display the result instead of displaying in that form it opens new datasheet view and display the result.
I want to display the result in the same form in Tabular format.
please let me know if it is possible