Multi-select list box

[E.Q.]

I've developed a training tracking application and showed it to my fellow
supervisors and bosses from various departments. They've requested somethying
beyond my MS-Access skills. They would like to select multiple "milestones"
as they relate to specific "objectives" when tracking training.

Some background; two tables in the application hold the objectives data

tblTrainingObjectives
lngObjID (PK)
chrPlantArea
chrObjectiveName
intObjType
chrDescription

tblObjSpec
lngSpecID (PK)
lngObjID (FK)
chrSpecName
chrTestQuestion

I currently have two tables to track training:
tblTracking
lngTrackID (PK)
chrEmpID
dtmWorkDate
etc.

tblTrainedOn
lngTaskID (PK)
lngTrackID (FK)
lngObjID(FK)
blnTrained
sngTaskHours

I am set up to track time spen on each Objective in tblTrainedOn. I used the
wizard to generate a form using tblTrackin as the main form and tblTrainedOn
as the subform. My fellow supervisors would like to track each "milestone"
(which as I have here is uniquely identified by tblObjSpec.lngSpecID) by
having a "drop down" list and select all that were covered during a given
training day.
I believe a multi-select listbox might work, but I've never configured one;
my question is, what kind of output does this provide and how can I get the
data I want into the records and future reports?
To give an idea of the scale, I've received 185 "milestones" to include,
each relating to one of 44 objectives... So far, no objective has more than
about nine milestones associated with it.
We'd like to generate reports to track training... to see which milestones
have been covered. For example, we'd like to be able to see when an employee
received instructions pertaining to tub management (milestone) for the fine
screen building (objective).
Any suggestions for a multi-select technique (whether listbox, pop-up form,
or whatever) will be appreciated.
Peace.
EQC

 

[Larry Daugherty]

Access Help regarding MSLB is pretty good.

In broad strokes the main thing about multi-select list boxes is that
you must interrogate every item in the list to determine if
".Selected" is True and to take appropriate action.

HTH

 

[Tony Toews [MVP]]

In broad strokes the main thing about multi-select list boxes is that
you must interrogate every item in the list to determine if
".Selected" is True and to take appropriate action.

And you must do so using VBA code.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/