Too Few Parameters 2

[isladogs]

Several things

1. Add the filter clause to the strSQL statement and don't forget the delimiters - see post #2

2. What is rsfiltered and why do you need it?

 

[jamhs]

Thanks Ridders

Changed to below but still not updating the record may have to find another way of doing this.

strSQL = "SELECT Log.EmpName, Log.DateReq, Log.MGR_Comments, Log.Approved, Log.Declined, Log.Cancelled" _
& "FROM Log " _
& "WHERE (((Log.EmpName)= '" & [Forms]![Log_MyTeam]![EmpName] & "') AND ((Log.DateReq)= #" & [Forms]![Log_MyTeam]![DateReq] & "#));"

Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)
rs.Edit
rs!Approved = True
rs!MGR_Comments = Me.MGRComments
rs.Update

 

[Minty]

You don't appear to be actually selecting a specific record in the second recordset?

EDIT - Missed the other posts - but my point still stands you aren't selecting a specific record.

 

[jamhs]

Thanks all Fixed now Finally