RecordSet Not Updateable

[AC5FF]

So I've worked myself into a small bind that I've not been able to figure a way out of.

I {had} a form working just how I want, allowing the end user to see a set of records and make changes as needed (basically all they do is update a flag). However, I wanted to highlight certain records that had historical notes, so instead of looking for notes on 50+ account numbers, using a conditional format I highlight certain accounts with notes attached.

Getting the conditional formatting to work was a challenge; and the only way I could come up with is to add in a subquery that would count replies for each account. If >0 then highlight that number. In doing so, that made my form's query not updateable. I immediately knew why when I first ran the new query (dang sums!!!)

So, I've been trying to figure out a way to get around this. I thought I would just do a make table query, use that table in my form's query instead of the subquery doing the sum. But still the form's query is not updateable.

No changes were made to the original query that was updateable, other than adding in this second table and one field from it.

Now I'm at a complete loss for where to look...


I'm not sure what else to add here to help figure this one out. If anyone can help me get over this stumbling block I would appreciate it though.

 

[CJ_London]

you could try changing the form recordset type to dynaset inconsistent updates

 

[AC5FF]

I did find this example. About half way down the page it explains using a make table query to overcome the not updateable hurdle.

It describes exactly what i've done; yet mine continues to be unupdateable.

Wierd
....

Code from my form's query that isn't working:

SELECT OutFileLog.AccountNumber, OutFileLog.ReportDate, OutFileLog.Runtime, OutFileLog.Avg, OutFileLog.Send, IIf(Weekday([outfilelog].[reportdate])=1 Or Weekday([outfilelog].[reportdate])=7,2,Weekday([outfilelog.reportdate])) AS reportday, [Reply Counts].CountOfReportDate
FROM [Reply Counts] RIGHT JOIN OutFileLog ON [Reply Counts].AccountNumber = OutFileLog.AccountNumber
WHERE (((OutFileLog.ReportDate)>=Date()-3) AND ((OutFileLog.Runtime)>0) AND ((IIf(Weekday([outfilelog].[reportdate])=1 Or Weekday([outfilelog].[reportdate])=7,2,Weekday([outfilelog.reportdate])))=Weekday(Date())));