Wish to populate 2 other fields on After Insert Event

[pbassett]

I have a form that displays FTEs by month for several Departments within a project that the user selects from a combo box.

In addition to updating FTE data, the user can add records. They can enter a new Department and FTEs for the months. However, (this is the sticky part), I have 2 other fields in the table: Tier and Order. This is because these departments are grouped in Tiers (1, 2, or 3) and Order (1-n) so that I can display records in 3 subforms (1 for each Tier) and list them sorted by Order. The user can not be expected to enter the Tier and Order, so I have to do it programatically.

How can I add Tier and Order to the record after the user enters the other fields? I was thinking of the Insert Event procedure, but I'm not sure how to determine which record I just added

Thanks,
Pete

 

[SydneyGeek]

If it's a new Department, does it have Tier and Order data, or have I misunderstood you?

Denis