Got a tricky situation I could use your help with. I have a subform that I want a field that is conditionally formatted based on a value that I don't want to display on the subform ([Status] field exists in the subform's table). I have a button on the form that updates the [Status] value using the following code:
CurrentDb.Execute "UPDATE [Groups Master] SET Status = " & Me.cboGroup.Column(7) + 1 & " WHERE GroupID = " & Me!GroupID.Value
The code works and updates [Status] correctly, but the value on the subform doesn't update. I suspect it's because I'm using CurrentDB.Execute to update the database on the back end and that doesn't refresh the current subform. I thought using Me.Refresh would pull the updated value into the subform. Nope.. I also tried requery to see if I could get it to pull the new value. No luck. If I close and reopen the form, the field is updated to the correct value.
How do I pull the updated value into the current subform?