Hi All
I'm abit struck on open this recordset and with Parameters with a Query
Its ran through a Button on a form
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("TeamADC")
rs.Edit
rs("Approved") = True
rs("TMS") = Me.MTS
rs.Update
Query:
SELECT Log.Name, Log.DateT, Log.Comments...