Displaying query results in a listbox

[Maldini]

Hi,

Is there anyway to display the results of a query in a listbox, whilst not having the standard query results screen popping up?
Also, any idea on how to clear the contents of a listbox on form load? Since there doesn't seem to be a clear method for the listbox...

Thx
Maldini

 

[Lightning]

Copy the SQL code for your query into the listbox's Row Source property.

In Query Design view select VIEW|SQL VIEW from the toolbar. Copy the SQL code to the clipboard. Open your form, select the listbox and Paste the code into the Row Source property.

This will also run the query every time the form is opened, so the listbox will always open with the up-to-date query results displayed.

HTH
Lightning