ComboBox...... Easy One!!

[themanof83]

Hello People,

I want to use a combobox or a listbox to filter a report. I have a table (tbl1) that has a field named load. This field could be anything but is often the same for a number of records, generally there are 3 or 4 variations.

So basically I would like a combobox to display these variations so that the user can select one of them. I imagine that SQL is the way forward on this but I'm fairly new to it all! The report part works fine.

Any help would be much appreciated...
Thanks

 

[ezfriend]

This could ba simple select statement.

ComboBox1 Properties
Row Source Type = Table/Query
Row Source = SELECT DISTINCT [Load] FROM tbl1 ORDER BY [Load]

 

[CEH]

Confusing post to me... Do you mean you want the Combo or listbox to pick which report to open? Or for the combo or listbox to set a criteria for which the report is built?