Thanks Bruce
That has been very helpful. I will read up on VBA help.
Richard
"BruceM via AccessMonster.com" wrote:
> If the idea is that you will schedule people for individual courses, the
> situation is that one course may be attended by many people, and one person
> may attend many courses. This is known as a many-to-many relationship, so
> you need a third table (Enrollment) to resolve the relationship.
>
> tblCourse
> CourseID
> Dept
> Description
> etc.
>
> tblStudent
> StudentID
> FirstName
> LastName
> etc.
>
> tblEnrollment
> CourseID
> StudentID
>
> There are other considerations, such as whether a course is offered at
> different times, and whether you need the instructor information in the
> record.
>
> To briefly answer your specific question, for the report you need a query
> that combines the appropriate tables and contains the fields that need to be
> on the report. To print a report for a single record or a limited group of
> records, see VBA Help for information about OpenReport. Specifically, the
> Where argument is used to limit the report's recordset.
>
> Richard wrote:
> >Hi
> >
> >I am using Windows XP and Access 2000.
> >
> >The database is for shceduling courses.
> >
> >I have 2 tables. TRAINW and Courses. A form called ChooseCourse, and a
> >report called PrintWaitingList.
> >
> >The form needs a Combo Box where users can select a course from the Courses
> >table, then click on a 'Print' button that prints off the PrintWaitingList
> >report.
> >
> >The PrintWaitingList report needs to have the Course name field and other
> >fields like the name of the person which should come from the TRAINW table.
> >
> >Any help with this would be most appreciated.
> >
> >Thank you in advance.
> >
> >Richard
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...forms/201005/1
>
> .
>
Similar Threads
