User Profile

Collapse

Profile Sidebar

Collapse
BobVezz
BobVezz
Last Activity: Jan 25 '12, 03:11 PM
Joined: Jan 23 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BobVezz
    started a topic Set Control Source Value in SubReport at Runtime from MainReport
    in Access

    Set Control Source Value in SubReport at Runtime from MainReport

    I have a report and a sub-report. I want to reuse the sub-report in the main report, but change the Control Source of a TextBox for each use. I am coding:
    Code:
    Reports![rptMain]![SubReportControlName].Report![Title Label].ControlSource = "=""Value A"""
    I consistently get:

    Run-time Error 2455 You entered an expression that has an invalid reference to the property Form/Report.

    The code...
    See more | Go to post
    Last edited by NeoPa; Jan 25 '12, 06:52 PM. Reason: Added mandatory [CODE] tags for you
    • BobVezz
      replied to Running VBA code when a user closes database using (x)
      in Access
      Don't know if you are sill looking at this. First rule of coding is to accept the fact that end users are dumb and you have to code around them. I have a similar situation. All I did was simply disable the "Close" button via the form's properties. Now they MUST use the Exit/Close button I privided. Hope this help(s)(ed).
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...