Forum Discussion
Problem Updating Field from External Table
I have a form name [Jobs] which has subform [JobDetails subform] connected. The subform has a field [EquipmentID] which displays the names of electronic equipment which is set to run an update query ...
If your subform is Bound to JobDetails table, then you do not need to run an Update query. changing the price on the subform will automatically be saved to JobDetails table. with what you are doing, there is a chance that you will get various "messages" from the system. since the Form is Dirty and you are updating Same Record using SQL. the system will know that the table has the latest version, therefore it will warn you with that. Remember what is showing in the Form is a Snapshot of the one in the physical Table. therefore if you show the record in the form, you must Edit it using the same form.