Carry over data question

[pncbiz]

I have a main form (Contracts) with a subform (subProduct). User enters contract details including the contracted company, then moves to the subform to select the Product Vendors and Products. For example, contract with Company A to sell three of Company's B's products (as well as Company C's, D's and E's, as applicable).



The list of products can be quite long for each contract, so I implemented carry over code (Allen Browne's) that works great when editing a contract. However, when entering a new contract, the carry over pulls the data from the previous product record, which is wholly irrelevant.

I'd like to have the carry over ONLY carry over data within the current contract, and not reach into the products associated with the last contract entered. Is that possible?

Thanks,
Phil

[June7]

Code is setting DefaultValue property?
When moving to new record row on main form, set subform controls DefaultValue to empty string. Use main form Current event.

If Me.NewRecord Then

[pncbiz]

Just wanted to follow up on this - wound up deleting the code altogether. As I dug into it a little more, I realized users wouldn't need much carryover, and just setting default values with VBA when needed would be enough. Thanks for your time!