Controlling Reports with list boxes

[David]

Hello,

I have set up a form in Access2000(no VBA) which has a
list box that I can use to make a selection in the
subform based on country. Is there a way to use a list
box (or the existing list box) to control a subselection
in a report.

Thanks for your help,

DM

 

[John Vinson]

Hello,

I have set up a form in Access2000(no VBA) which has a
list box that I can use to make a selection in the
subform based on country. Is there a way to use a list
box (or the existing list box) to control a subselection
in a report.

Thanks for your help,

DM

Yes; base the Report on a Query referencing the form control, with a
criterion like

=Forms!nameofform!nameoflistbox

However this only works for single-select listboxes; if you want to
use a multiselect listbox you'll need some code.

John W. Vinson[MVP]
(no longer chatting for now)