AfterUpdate on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Stengel - 19 May 2005 16:59 GMT

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

Reply to this Message

MacDermott - 20 May 2005 02:45 GMT

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

> I have 3 tables titled "Dept", "Event", Student",
>
[quoted text clipped - 14 lines]
>
> I need the DeptID stored, to autosync other forms to one already displayed

Reply to this Message