E
eklahorst
Hello, I have created a form in Access 2003. On this form is based upon a
query that has Department, Department Supervisor, Description, and then also
has profile number, list number. I have created an after update event that
will fill in the Department Supervisor after they select Department from the
department combo box. My question is it possible to have another after
update event happen that will fill the profile number and list number when
they select the description from another combo box? If so - how would I do
this? I created another after update event for the description but when I
select a description nothing fills in the text boxes for profile number and
list number. My code looks like this:
Private Sub Affected_Call_List_Description_AfterUpdate()
Me.Affected_Load_Profile = Me.Affected_Call_List_Description.Column(2)
End Sub
Private Sub Department_AfterUpdate()
Me.Department_Supervisor = Me.Department.Column(1)
End Sub
query that has Department, Department Supervisor, Description, and then also
has profile number, list number. I have created an after update event that
will fill in the Department Supervisor after they select Department from the
department combo box. My question is it possible to have another after
update event happen that will fill the profile number and list number when
they select the description from another combo box? If so - how would I do
this? I created another after update event for the description but when I
select a description nothing fills in the text boxes for profile number and
list number. My code looks like this:
Private Sub Affected_Call_List_Description_AfterUpdate()
Me.Affected_Load_Profile = Me.Affected_Call_List_Description.Column(2)
End Sub
Private Sub Department_AfterUpdate()
Me.Department_Supervisor = Me.Department.Column(1)
End Sub