mulitple select list query

[Guest]

Hello,

I have a simple salesperson and sales history query.

How can I create a form and subform like the following:

Main form has the first select from salesperson to salesperson i.e. sales07
to slaes12, the second select from sales date to sales date i.e. 1/1/2005 to
6/30/2005

So, the subform will list sales07 to sales12 and the date will be 1/1/2005
to 6/30/2005

Thanks

 

[Tom Ellison]

Dear Newbie:

What do you mean, "select from salesperson to salesperson?" Are you
selecting a range of salespersons according to the alphabetical spelling of
their last names? How does a range of salespersons seem a reasonable way of
selecting persons? Or is that what you mean?

If you have the four values in controls (and the form on which these
controls exist is open) then you can have your query reference the values in
the four controls. Where you might otherwise put the values into the query
to filter this, place a reference to the control. That control reference is
of the form:

[Forms]![FormName]![ControlName]

Replace FormName and ControlName with the actual names of the Form and
Control you use. As long as this form is open and the values are present,
the query will work from that.

Tom Ellison