L
LEB972
My main form has a pull down window to display vendor categories from a
vendor category table. Once a category is selected, there is a command button
called search that has a macro behind it that runs a select query based on
category selected from our vendor file. The results should display in a
subform. My problem is once the "search" button is clicked, a datasheet view
with no records in it appears. But once I "x" out of the datasheet view, the
subform appears and displays the correct query results.
How can I correct this so that when the search button is clicked, the
subform displays with the data in it instead of the datasheet without records
in it?
Thanks.
vendor category table. Once a category is selected, there is a command button
called search that has a macro behind it that runs a select query based on
category selected from our vendor file. The results should display in a
subform. My problem is once the "search" button is clicked, a datasheet view
with no records in it appears. But once I "x" out of the datasheet view, the
subform appears and displays the correct query results.
How can I correct this so that when the search button is clicked, the
subform displays with the data in it instead of the datasheet without records
in it?
Thanks.