Experts, I have a parent (frmParent) and subform (sub1) and they are linked by ID's as found in the properties.
I enter details in the parent such as currency (its a cbo) and DrawDate. After I enter the details on the parent, I go to the sub and want the same values to be inserted (for a new record but also to update for not a new record). it seems like I am having a refresh issue because the "new record" line in the subform seems to no longer appear after I click on it but the values seem to update tho but I just cant add more records. If I hit the F5 button, I will see the "new record" line appear again and I can add just a single record but will need to hit F5 once again to add another record.
I do have If me.dirty = false in the On Dirty event of the subform but that doesnt refresh like the F5 button.
Private Sub Form_Current()
Me.Currency = Me.Parent.Currency
Me.ValueDate = Me.Parent.DrawDate
Me.Refresh 'this doesnt seem to refresh like F5
Not sure if is is clear. Let me know if you need additional clarification.
Grateful for your help.
here is a screen print:
I put that code on BeforeInsert and it seems to work fine now. Havent tested completely though but I think its the solution.
thank you for the help and great explanation