D
Denis
Scenario: I have an Employee form which contains
a "Qualifications" subform (datasheet view).
Also on the Employee form, I have a series of listboxes
listing Categories of Qualifications and the
Qualifications within those categories. I.E. The Education
listbox would contain Education Quals (PhD, PG etc); The
Engineering listbox would include Eng Quals etc.
Incidentally, the Quals and Categories are all contained
in one table, and the listboxes are filtered based on the
Category.
My goal is to double-click on a specific qualification
within a listbox and populate the Qualifications subform
within the Employee form. (There is a one-to-many
relationship between the Employee table and the
EmployeeQuals table (source to subform).
I am trying to create an Append Query in the hopes of
passing the value found within the applicable listbox into
the Qualifications subform. However, I have the feeling
that this may not be possible. If it is, how do I do it,
and if it cannot be done using an Append Query, what are
my alternatives? I hope this has been clear enough.
Thank you
Denis
a "Qualifications" subform (datasheet view).
Also on the Employee form, I have a series of listboxes
listing Categories of Qualifications and the
Qualifications within those categories. I.E. The Education
listbox would contain Education Quals (PhD, PG etc); The
Engineering listbox would include Eng Quals etc.
Incidentally, the Quals and Categories are all contained
in one table, and the listboxes are filtered based on the
Category.
My goal is to double-click on a specific qualification
within a listbox and populate the Qualifications subform
within the Employee form. (There is a one-to-many
relationship between the Employee table and the
EmployeeQuals table (source to subform).
I am trying to create an Append Query in the hopes of
passing the value found within the applicable listbox into
the Qualifications subform. However, I have the feeling
that this may not be possible. If it is, how do I do it,
and if it cannot be done using an Append Query, what are
my alternatives? I hope this has been clear enough.
Thank you
Denis