Multiple Results

[Fie]

Hi,


I used an example that was in
http://www.databasedev.co.uk/combo_box_search.html that displays
results based on a search from a combo box... the problem is, is that i
was many results that are equil to that of the topic selected in the
combo box. Can anyone tell me or show me how to display all results of
a combo box search in a list box ??


thanks
fiona

 

[John Vinson]

Hi,


I used an example that was in
http://www.databasedev.co.uk/combo_box_search.html that displays
results based on a search from a combo box... the problem is, is that i
was many results that are equil to that of the topic selected in the
combo box. Can anyone tell me or show me how to display all results of
a combo box search in a list box ??

Create a Query referencing the combo box as a criterion, using

=[Forms]![NameOfTheForm]![NameOfTheComboBox]

as a criterion. Use this Query as the rowsource property of the
listbox.

In addition you will need to Requery the listbox in the AfterUpdate
event of the combo.

John W. Vinson[MVP]