Automatic Post field data to another field 2

[molly]

I need to figure out a way for an autonumber to also post to another field on the same Main form.

i have a Main form with a few subforms on tabs.
The Main form has a unique autonumber FormulaID. I need this main form record to post the FormulaID into another field which is in the same underlying table to a field named ProductFamilyID.

Afterwards, I have a way for the other Tabs subforms to link up via the ProductFamilyID.

This is my only idea. So if it is good, then i need the auto FormulaID to post to the ProductFamilyID too.

Thanks for any tips. Molly

 

[MajP]

Why? Two identical keys in the same record makes absolutely no sense. Tell us about your tables and what you are trying to accomplish.

 

[molly]

MajP - it is a complicated Sell Price form. I think I will stay with what is working. It is complicated since we are pricing 2 different pricing concepts with 1 bill of material (BOM) table. So I can't have one BOM use an autonumber formulaid and another bom table with a different autonumber series. The first part uses product family members or children. Hence, the main form needs to establish a product family ID.

Anyway, it would be nice for now to have a calc that takes the forms autonumber and posts it to a second field automatically. for now we type into the 2nd field. then the children records use this typed in product family ID.

molly

 

[PHV]

In the AfterInsert event procedure of the form:
Me![ProductFamilyID] = Me![FormulaID]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[molly]

to PHV: thanks. this works for me. It looks simple now. But I was stuck.

Molly