I'm stucked. I have a main form with a subform. What I would like to happen is this: When user updates field in main form, take this updated value and update all records in the subform *AND* have this changes reflected.

When your main form is updated, add the VBA code to update your subform. Use the Wizard to create a button to update the subform to get the code. Then add that code following formupdte.

The refresh works. Thanks very much for the refresh tip.

The passing of values from the main form to the subform is what I'm still stuck with. Any suggestion/advice will be worth trying, thanks in advance.