making two forms interdependant

[sachin123]

i want to update a form called points automatically when i update the form seats.

im trying to code it in VB but got no idea how to reference the external form

for example i want it to be

PointsAccumulated (of points table)= PointsSaved (in Seats table)

any thoughts

thnx
sachin

 

[MStef]

Try to do it via UPDATE QUERY or APPEND QUERY.

 

[sachin123]

hmmm is it not possible to do this via forms alone? (i.e. setting a 'after update/change' event to update the other form. the two tables are linked in my ERD

 

[MStef]

Send a short example of your DB.