G
Guest
Hi hope some one can help me on this. I have a form called Staff Entry for
entering staff into a table called Staff. On the form are among others two
combo boxes one called Department and one called Manager. These combo boxes
are based upon the Staff Table but on the Staff Table their data sources are
actually a table Called Departments. The Departments Table lists the
Department ID (Autonumber Primary Key) the department Name and the
departments manager.
What I would like to do on the Staff Entry Form is that when I select a
department that the Manager combo box is automatically populated with the
Departments manager.
I was using a after update event (If Department.Value="1" then
Manager.Value="Graham" which is fine but does not allow for changes in the
future so what I need but can't figure out how to code is (If
Department.Value="1" then set manager.value="department manager"
Corry if this is not making much sense I'll clarify any queries on reply.
Thanks in advance.
Graham
entering staff into a table called Staff. On the form are among others two
combo boxes one called Department and one called Manager. These combo boxes
are based upon the Staff Table but on the Staff Table their data sources are
actually a table Called Departments. The Departments Table lists the
Department ID (Autonumber Primary Key) the department Name and the
departments manager.
What I would like to do on the Staff Entry Form is that when I select a
department that the Manager combo box is automatically populated with the
Departments manager.
I was using a after update event (If Department.Value="1" then
Manager.Value="Graham" which is fine but does not allow for changes in the
future so what I need but can't figure out how to code is (If
Department.Value="1" then set manager.value="department manager"
Corry if this is not making much sense I'll clarify any queries on reply.
Thanks in advance.
Graham