Results 1 to 12 of 12

Thread: Help Me Please!!!

Threaded View

  1. #12
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,513

    Re: Help Me Please!!!

    There are acouple of things you can try.

    Close the DE recordset
    Code:
            If de.rsCommand1.State = adStateOpen Then
                de.rsCommand1.Close
            End If
            rpt.show
    You would replace rsCommand1 ine the code above with the name of the recordset in your DE. The recordset name is the command name with a "rs" in front of it. ( command name is "Names" then recordset name is "rsName"

    or try requerying the recordset

    rpt1.show
    de.rsCommand1.requery
    Last edited by wes4dbt; Sep 18th, 2007 at 12:06 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width