Results 1 to 2 of 2
  1. #1
    wucke is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    1

    Image on Report is Visible, if CheckBox on Form is True?

    Hi Guys,



    I'm new here, and in Access itself.
    Need you to help me with one problem. I want to link CheckBox on a Form with Picture on Report. If CheckBox is true, then picture on report is visible, and otherwise.

    I am trying to do this for couple days, but I have no luck. Anyone help pls...

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    Will the form be open when the report loads? If so, get the value of the checkbox in the report open event and show or hide the report image control accordingly.
    Or pass an argument in the report opening (maybe 'Chkd' or 'Unchkd') and do the same based on the argument parameter. One method looks backward, the other is a forward pass.
    The latter method allows you to close the form as part of the process if you don't want it to remain open. You'd have to provide the form and/or control names in question and what is it that opens the form (command button?) if you need further help. Or you could Google Docmd.OpenReport and/or something like 'refer to controls on open form'.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. visible form but not have focus when true
    By Ruegen in forum Programming
    Replies: 5
    Last Post: 04-30-2015, 10:31 AM
  2. Replies: 16
    Last Post: 03-26-2015, 08:35 PM
  3. Replies: 7
    Last Post: 05-30-2013, 04:22 PM
  4. Replies: 4
    Last Post: 05-29-2013, 01:29 AM
  5. Report Fields Visible Based on Checkbox
    By ghillie30 in forum Access
    Replies: 2
    Last Post: 09-21-2011, 09:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums