Autoupdate Record

[andy-29]

Form [Edit Marker Info]



I would like to create an after update event on Text Box[MMReleased], when updated it would trigger an update query.

The query will update the value of a field[RequestStatus] on table[Requests] to “Completed”.
But it should only do this on the matching current record being modified.
Record is based on [StyeID]

[June7]

CurrentDb.Execute "UPDATE Requests SET RequestStatus='Completed' WHERE StyleID=" & Me.cboStyleID

[andy-29]

Private Sub MMReleased_AfterUpdate()

CurrentDb.Execute "UPDATE Requests SET RequestStatus='Completed' WHERE StyleID=" & Me.cboStyleID

End Sub

I get an error when executing

[June7]

I made assumption StyleID was number. Since it is text, need apostrophe delimiters.

CurrentDb.Execute "UPDATE Requests SET RequestStatus='Completed' WHERE StyleID='" & Me.cboStyleID & "'"

[andy-29]

That worked, thank you very much!