After update

[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?

 

[Steve Schapel]

Michael,

What is the nature of the relationships between these tables. It would
be unusual, in my experience, to need to use code to assigne a value
such as the DeptID in the Student table. What do you mean by "for
further linking"? On the basisi of what you have said so far, I can
only assume that you have Events, and each Event is related to one of
the Departments, so you indicate which Department the Event is related
to via the entry of the Dept in the Event table. Well, fair enough,
although it would be more usual to use the DeptID for this rather than
the Dept field. And than you have Students, and each Student is related
to one of the Departments, so you indicate which Department the Student
is related to via the entry of the Dept in the Student table. So, why
not do the same with Student as you did already with Event, i.e. use a
combobox whose Row Source is the Dept table, to enter the DeptID into
the Student table via the Student form?

 

[Michael Stengel via AccessMonster.com]

i need the deptID to autosync other popup forms to one displayed.

 

[Steve Schapel]

Michael,

I am very sorry, but I am still just as much in the dark.