I would like to place an update button on a form that updates select records in the form. There are several thousands records in a form (Test)... I have an excel file (Data) with three columns in it ID, Call, Date. In the form there are those same fields except there are empty. Is there a way that the excel file can be used to update those empty fields in the record?
So, if in Data:
ID Call Date
101 Normal 8/8/2014
When the button is clicked the record that matches 101 has the field Call updated to Normal and the field Date updated to 8/8/2014. Thank you.
So, if in Data:
ID Call Date
101 Normal 8/8/2014
When the button is clicked the record that matches 101 has the field Call updated to Normal and the field Date updated to 8/8/2014. Thank you.
