Is it possible using a Macro to get a Sub-Form field to update a field on the Main form. I have a Finish date field on the main form. on a sub form I have a extention request form with a Extention start date and extention period field. I an trying to get the Extention field to update the Finish Date field after being updated. I cannot work out the correct syttax to create the SetValue within a Macro. There maybe a solution within some VB or using the On Exit on the Sub-form.