Joe,
I have developed a calendar schedule module that I thought you might be
interested in having it implemented in your database. It was developed for a
database used to schedule training classes. The training facility can be
selected to limit the training classes displayed in the calendar to a
specific facility. You can change the month and year of the calendar to
limit the training classes displayed in the calendar to a specific year and
month in that year. By simply making a new selection in one of the
drop-downs, you can change what faciity the training classes are diaplayed
for and what month and year the training classes ocurred. To schedule a new
class, you click on one or more dates for the class in the calendar and then
click the "Schedule" button in the menu at the top of the screen. The
"Schedule" button opens a form to add a new training class on the dates you
previously selected. You can also click on any day to edit the schedule of
the classes shown on that day. At any time, you can click on Print in the
menu at the top of the screen and printout the calendar that is on the
screen. The calendar schedule module can be easily modified to meet your
specific needs. I can email you a screen shot of the calendar schedule
module if you are interested.
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com www.pcdatasheet.com
"Joe" <jc**********@c omcast.net> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.com.. .
I have 2 multi-list boxes, 1 displays course categories based on a
table called CATEGORIES. This table has 2 fields CATEGORY_ID,
CATEGORY_NAME
The other multi-list box displays courses based on a table called
COURSES. This table has 2 fields CATEGORY_ID, COURSE_NAME.
The CATEGORY_ID is a FK in COURSES and a PK in CATEGORIES.
I want to populate the course list box based on any category(s)
selected in the 1st multi-list box. How would I go about doing
something like this?