Your form should be based on a query on the CoursesTaken table which
references a combo box of employees on the same form. I'll come back to the
combo box later, but the query would be:
SELECT *
FROM [CoursesTaken]
WHERE [EmployeeID] = Form![cboEmployee];
Make the form a continuous form. If you use the form wizard to create it
select 'tabular' as the layout. You only need controls in the form for the
CourseID and other columns like the date taken etc, not for the EmployeeID.
In the form make the control bound to the CourseID column a combo box set up
like this:
ControlSource: CourseID
RowSource: SELECT [CourseID], [CourseName]FROM [Courses] ORDER BY
[CourseName];
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm
If your units of measurement are imperial rather than metric Access will
automatically convert them. The important thing is that the first dimension
is zero to hide the first column and that the second is at least as wide as
the combo box.
In the form's header add a combo box and set it up like this:
Name: cboEmployee
ControlSource: Leave this blank
RowSource: SELECT [EmployeeID], [FirstName] & " " & [LastName] FROM
[Employees] ORDER BY [LastName], [FirstName];
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm
In the AfterUpdate event procedure of this combo box put:
Me.Requery
This requeries the form so it shows only the courses for the selected
employee. If you are unfamiliar with entering code in event procedures you
do this by selecting the cboEmployee combo box in form design view and
opening its properties sheet if its not already open. Then select the After
Update event property in the properties sheet. Click on the 'build' button;
that's the one on the right with 3 dots. Select 'Code Builder' in the
dialogue, and click OK. The VBA window will open at the event procedure with
the first and last lines already in place. Enter the line of code between
these two existing lines.
When the form opens it will not show any records. Select an employee from
the combo box and it should then show any courses taken by the employee.
You can add a new attendance at a course for the current employee by adding a
new record in the blank row below the existing course attendance records
simply by selecting a course in the combo box and entering the date taken etc
as appropriate.
Ken Sheridan
Stafford, England
Thank you for helping! Here is my next problem
I have created the tables to store all the information. My question now, is
how do I get it all to connect? I have created a query and a form but I don't
think I did it right. I would like to be able to type in the employee's name
and have all the training they have completed show up.
If I type information such as employee name and course into a form, how is
the data stored? Is it saved somewhere?
I'm trying to enter employee training information. I want to be able to type
in an identifier (last name or employee number) and it will bring up
[quoted text clipped - 33 lines]
--
Message posted via AccessMonster.com
.
