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 AfterUpdate, to pull in the price of that equipment in the [Equipment] table with matching [EquipmentID]. In order that only this record gets updated, I add to the update query the autonumber field [ID] in the [JobDetails] table where the associated [ID] on [JobDetails subform] matches. When the query is run however, I get the prompt asking me to enter the value for that field even though an ID number is displayed. As I want to be able to change the value of the price that is populated, I need for only the current records price to be updated after I select the name of the equipment.# Any help on this would be greatly appreciated.