We have an access db that tracks different things like mileage etc. When the user enters the date for example 4-1-2007 to 4-30-2007 and does a show range and process totals we get the RunTime Error 3360 - Query is too complex. Here is the piece of code that errors out. The db1.Execute line is the one that is highlighted when we debug.
Set rcst1 = Forms!frm_IFTA_Mileage_EntryEdit.Child41.Form.RecordsetClone
If rcst1.RecordCount <> 0 Then
db1.Execute ("UPDATE tbl_Haul_Data_Mileage SET ErrCode = " & intErrCode & " " & strWhereClause & ";")
Set rcst1 = Nothing