Recent content by Bill_P

Resolved This difficulty has been resolved. The Report rptMemberProfile has 7 sub reports, the last of which had a Parameter Query as its record source. A simple statement by John Viescas (johnv@viescas.com) that DoCmd.OutputTo can NOT include Parameter Queries enabled this to be resolved...

Attachment of the two queries Refer attachment

Response to Uncle_Joe Yes, there would be a common reference to a Table. Is there a technique to get around such an occurrence?

DoEvents Yes, I've tried that. Yes, there is much more code BUT I need to know WHAT to look for as the error is much deeper, but where?

Errors off! I'm sorry, but I do not understand what I would do to do that. As stated, the program works without error up to and including the DoCmd When debugging to the Docmd, the lr_Data![objects] exist; Once the DoCmd has executed (I believe without error), the lr_Data![objects] are...

' Can anyone suggest what to look for to resolve this. Dim l_Database as DAO.Database Dim l_Query as DAO.Querydef Dim lr_Data as DAO.Recordset Dim ls_HTML_Body as String On Error GoTo Errs_This_Module_Name Set l_Database = DBEngine(0) (0) Set l_Query =...