Multiple choices.

[Maracay]

Hi Guys,

I have previously post this threat, I had have some answer but I haven’t
been able to do it, what I want is, before running a reports I need to choose
several records from a master table, I was thinking about two list box and
moving the data from a list box to another list box, I received some feedback
about this idea but I couldn’t do it. I wonder if someone has another idea of
how to choose several records from a master table and take this selection to
filter a report or a link where I clearly can see how to do the 2 list boxes
routine.

Thanks a lot.

Any help will be appreciated

 

[Chuck]

Hi Guys,

I have previously post this threat, I had have some answer but I haven’t
been able to do it, what I want is, before running a reports I need to choose
several records from a master table, I was thinking about two list box and
moving the data from a list box to another list box, I received some feedback
about this idea but I couldn’t do it. I wonder if someone has another idea of
how to choose several records from a master table and take this selection to
filter a report or a link where I clearly can see how to do the 2 list boxes
routine.

Thanks a lot.

Any help will be appreciated

This is cascading List Boxes. It can all be done nice neat and clean in code,
but I don't write code. So . . . make a query that will return the data form
your table(s) based on the multiple selections of the first List Box. Make
that query be an Append query. Append the results of that query to a temp
table. Make a second query that will return the data from the first temp table
based on the selections of the second list box. Make that query be an Append
query. Append the results of that query to a second temp table. Base your
report on a query of the second temp table.

When you are finished with your report(s), clear all the records from the two
temp tables but keep empty tables.

Chuck