I have found this link to a question similar to one I have. Though after reading through it I cannot wrap my head around how it ended up working.
http://www.access-programmers.co.uk/forums/showthread.php?t=192900
In my situation, I've got an unbound form with a combobox that filters a subform (which is set to continuous). I have a combobox on the subform which will allow the user to change a contact's connection to a supplier.
I've added the primary key for the record but running the update query asks if I want to change all values. I believe my problem is I am not where how to incorporate a Me.Whatever to make this work as they have it in the link.
Not sure if the SQL is necessary but here it is anyway
http://www.access-programmers.co.uk/forums/showthread.php?t=192900
In my situation, I've got an unbound form with a combobox that filters a subform (which is set to continuous). I have a combobox on the subform which will allow the user to change a contact's connection to a supplier.
I've added the primary key for the record but running the update query asks if I want to change all values. I believe my problem is I am not where how to incorporate a Me.Whatever to make this work as they have it in the link.
Not sure if the SQL is necessary but here it is anyway
Code:
UPDATE tblSuppliers INNER JOIN (tblContactType INNER JOIN tblContactInfo
ON tblContactType.TypeID = tblContactInfo.TypeID) ON tblSuppliers.SupplierID = tblContactInfo.SupplierID
SET tblSuppliers.Supplier = [Forms]![frmContactMenu]![frmContactDisplay]![cboChangeSupplier]
WHERE (((tblSuppliers.Supplier)=[Forms]![frmContactMenu]![cboSupplierContactSelect]));