Hi, when a user updates my form, it does not automatically update the table. I also have queries running to update certain fields in the table, and this is also not updating the form.
I have checked the Form properties, and the Control Source is the correct table.
I have tried to get around the issue through code in the form on the AfterUpdate Event, however my code isn't working.
Private Sub Housing_Officer_AfterUpdate()
CurrentDb.Execute "Update tblVacantUnitStatus_ALLDATA (Housing_Officer) Value ('" & Me.Housing_Officer & "')"
End Sub
Any suggestions greatly appreciated!