D
DubboPete
Hi all,
I have a subform which lists over 150 employees as the column headers. This
is how we wanted it to look. The reason being, we want to see what
employees have attended a particular course, and this method suits the bill.
It's based on a crosstab query, which is based on TblTraining
The query includes fields [course], [employeenumber] and [coursedate]
The rows indicate [course] that these employees have attended, the columns
indicate the [employeenumber], and the grid displays the date they attended
the relevant course.
What I would like to do is click on a column header on the subform, and have
[text0] do a Dlookup of [firstname] and [surname] for the relevant
[employeenumber] column heading. This is because not everyone remembers
Employee Numbers!
Is it possible to identify the column heading [employeenumber] for the
DLookup?
thanks in anticipation ....
DubboPete
I have a subform which lists over 150 employees as the column headers. This
is how we wanted it to look. The reason being, we want to see what
employees have attended a particular course, and this method suits the bill.
It's based on a crosstab query, which is based on TblTraining
The query includes fields [course], [employeenumber] and [coursedate]
The rows indicate [course] that these employees have attended, the columns
indicate the [employeenumber], and the grid displays the date they attended
the relevant course.
What I would like to do is click on a column header on the subform, and have
[text0] do a Dlookup of [firstname] and [surname] for the relevant
[employeenumber] column heading. This is because not everyone remembers
Employee Numbers!
Is it possible to identify the column heading [employeenumber] for the
DLookup?
thanks in anticipation ....
DubboPete