While open the report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • salimudheen
    New Member
    • Jan 2007
    • 14

    While open the report

    While i try to open the report from my system is okey. But in network system it displays the error message "You can't disable a control while it has focus". But actually i never focus any control. Then y this happened....
  • nico5038
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    How do you open the report?
    Looks to me there's some VBA code trying to disable a control or setting the focus...

    Nic;o)

    Comment

    • salimudheen
      New Member
      • Jan 2007
      • 14

      #3
      Using vba code just i open the report. My code in my form is
      sub prinrep_click()
      if date1 is > date2 then
      docmd.gotocontr ol date1
      else
      docmd.openrepor t "Myreport",acvi ewpreview
      end if
      end sub

      Comment

      • nico5038
        Recognized Expert Specialist
        • Nov 2006
        • 3080

        #4
        Just try this sub with only the "Docmd" command.
        Testing or the dates in a range are in the proper sequence isn't necessary as a BETWEEN in a query will work both ways correct.

        Nic;o)

        Comment

        Working...