Matt Roell said:
I have a database that keeps track of usage for a computer lab at a small
college. I have four tables that all the data is stored in. What I would
like to do is make a form that has four List Boxes, (Log, Year, Month,
Week); I want the user to select what log (the different areas of the lab)
they want and which year, month and week to make a report. I would also like
it so that a user could select more then one category from the list boxes.
Any help is greatly appreciated.
What specific help do you need, Matt?
It is possible to coordinate or synchronize List or Combo Boxes so that if
you choose a particular Log, the only Year values that are displayed are
those available for the chosen Log, and when the Year is chosen, only the
Month values applicable to that Year, and when the Month is chosen, only the
Week values applicable to that Month.
It is also possible to have "multiselect" List Boxes in recent Versions...
but that would be inconsistent, in general, with the previously-described
approach. You have to pick up the selected values from code if you use this.
Perhaps you want to allow the user to specify a From and To range on the
dates. Perhaps there are few enough Logs that you could show all of them and
allow multiselect of the Logs, and a range on the Dates.
You'll need to have a clear idea of what you want to provide, and describe
it in some detail, before anyone can give you worthwhile suggestions.
Larry Linson
Microsoft Access MVP
