Find Last Record by Primary Key on Subform then Add New Record and Pass Thru Values

[dipitiduda2]

Hello All: I'm an Access newbie so I might not use the correct terminology. I am trying to figure out how to add a new record and pass through values from the open subform to the new form - both subforms share the same recordset. I'm using the Record Selector to add a "New (blank) record". When the new record is open onscreen I want a value "End Balance" from the record I navigated from to be inserted into another textbox "Begin Balance" in the new record. And, I want the value "Calendar Year" from the record I navigated from to be iterated to the next year and inserted into the same textbox in the new record.

Do I just use OpenArgs to pass the values through from the active record to the new record? If so, does anyone have a code example that I can follow?



Any help is greatly appreciated!

[June7]

Where does this Balance value come from? Do you have transaction records that this is calculated from? Ideally, calculated data is not saved to table, especially aggregate data - calculate when needed.

[dipitiduda2]

Hi June7,

Initially, the Begin and End Balance values will be data entered by the user on a subform. This will be the 1st row that exists for the ProgramID (PK in main table, FK in subtable). Thereafter, the BeginBalance of the 2nd subrecord has to be the same value as the EndBalance in the 1st subrecord.

No, the Begin and End Balance fields are not calculated.

[June7]

Okay, still no need to duplicate the Balance. Here is one method to retrieve the value of field from another record in same table http://allenbrowne.com/subquery-01.html#AnotherRecord

However, if you must save, one approach may be to programmatically set the DefaultValue property of the BeginBalance control with the EndBalance value
http://access.mvps.org/access/forms/frm0012.htm
http://allenbrowne.com/ser-24.html

[dipitiduda2]

thank you very much...just needed a little guidance on how to proceed. Cheers!