AfterUpdate on a form

[Michael Stengel via AccessMonster.com]

I have 3 tables titled "Dept", "Event", Student",

Table Dept Fields are: DeptID (Autonumber) & Dept (text)

In Tabel Event I have the field : Dept

In Table Student I have the field: DeptID

On a form I have a Combo Box which allows the user to select a Dept and
store the value selected in th Dept field of the Event Table.

For further linking I also need to store the selected DeptID on the Student
table in DeptID field.

Was told to do this with the "afterupdate" event but have been unable to
accomplish this. Any ideas?

I need the DeptID stored, to autosync other forms to one already displayed

 

[MacDermott]

If you need to store the same data in two places, just for linking, you
probably need to reconsider your design.
Can a student attend events in only one department?
If a student can be associated with more than one department, you
shouldn't be storing that information in the Student table anyhow.

HTH