After_Update Procedure

[Nad_user]

hi,



I have a combo box called Course in a form called Employee (using table Employee) this combo box gets information from another table called Course. and I have another field in the form employee called Course_id.

what i need is: when i select any value from the combo box course (Say Math which has ID= 1), i want the field course_id to be filled with the id of the course.

I created an after_update event on the field Course but i cannot seem to find the right code to write in it that does the work.

[maximus]

let me describe a hypo situation:

I have a table course with columns: {ID(PK),CourseID,Subject}
and in employee table I have two Fields CourseID, Subjects
Now I want when I select subject the code is automatically populated.
Go to the Combobox in the employee table that you use to select Subject. in the underlying Query Select all the fields ID,CourseID,Subjects
Now make sure the the Column Count is Three.
in this case the column Index will be in this order:
ID=0
CourseID=1
Subject=2

This will obviously depend upon the order of your fields.
Suppose you Select only Subjects as the First Column of the Query and CourseID as the Second Column then the Index will be 0 , 1.

Now in the afterUpdate of the ComboBox put the following Code:
Me.CourseID=Me.Subjects.Column(ColumnNumber)

Here is a practical e.g.
Me.DepartmentName = Me.Department_ID.Column(2)

When the user Selects Department_ID, DepartmentName is populated with the value pertaining to that Department_Name from Column 2 of the combobox Department_ID. Here Column 2 is Department Name.

if this solves your problem mark the thread solved.

[Nad_user]

Thanks a lot! it work perfectly

[maximus]

No probs welcome to the Forum!!!!!