do not open table when running a query

[marlun]

Hi.
I have a problem. I ahve a search-form. I select a S/N in a combobox, then I have a run query-button. When push the button a table with my search results pops up, I don't want it to do that, I want it to show the results in a listbox on the same form instead.

 

[bjpearce]

The approach I would take is to put an event (update or on click) on the selection combo box. This would simply execute requery.list1 where list1 is your list box. The query associated with the list box should have a criteria of the contents of the combo box.
Their is no need for an execute buttonit will happen automATICALLY YOU SELECT SOMETHING FROM THE COMBO LIST