event procedure code help needed

[charityworker]

Help, I need a hand developing some lines of code (event procedures I think) for a database. I have one main form and three extra forms that all update a single record. The problem I am having is that I need those additional forms feeding data back to the same record in the same table. The main record has an ID entitled TenderID, the main database is TenderInfo and the additional forms are PartA, PartB and PartC. I therefore need code that will:

1) enable me to open a second, third or fourth form that matches the same record as the main form – I think it needs an ON LOAD EVENT PROCEDURE
2) save the information (or update) entered to that same record ON CLOSE

I’m very new to Access so any help would be really helpful! I think I am clearer about what I need than in my earlier posts.

 

[RuralGuy]

Start by using a Query of your table to avoid record locking issues. All 4 forms need to be open at the same time?