Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2018
    Posts
    9

    Change settings in a Report based on Changes made in a Form

    I have a form that if a checkbox is selected it darkens out the background of a textbox. I am having problems sending these changes to the report that is generated form this form. Can someone please help


    Here is the code I am trying:
    Code:
    If Me.Check88 = True Then
    Me.Cell_1_Comments.BackColor = vbBlack
    [Report]![Tie In]![Cell 1 Comments.Backcolor = vbBlack]
    ElseIf Me.Check88 = Not True Then
    Me.Cell_1_Comments.BackColor = vbWhite
    End If

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    use conditional formatting in the report, or code in the report open event, not code from some external form.
    You can't change characteristics of a report when it's already open, no matter what you're trying.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    why not just do conditional formatting on the report itself?

  4. #4
    Join Date
    Aug 2018
    Posts
    9
    That makes since. Thanks everyone, I apparently had a little brain fart there..

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

Similar Threads

  1. Replies: 1
    Last Post: 02-11-2019, 08:54 PM
  2. Replies: 1
    Last Post: 07-09-2017, 03:27 AM
  3. Message Box if a change has been made
    By hazeleyre23 in forum Access
    Replies: 2
    Last Post: 03-30-2016, 09:57 AM
  4. Track who made last change
    By BRZ-Ryan in forum Database Design
    Replies: 9
    Last Post: 01-08-2014, 11:47 AM
  5. Replies: 3
    Last Post: 12-11-2012, 09:12 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