Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Changing properties of one open form from another

    I have 2 forms open. One, an item creation form with specifications entered into it and another form confirming if they want to save the item. If they click yes it evaluates for missing but necessary fields. If any are missing, I would like to change the properties of the corresponding field on the original form so that the background color of the text box turns yellow. However, I'm not sure how to change the setting on another open form. If it was the same form, it would be something like Me.Field.BackColor = 65535 for yellow. How do you change properties on a different open form? Thanks Joshua

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    I keep this site bookmarked for when I can't remember

    So in your case it would be like:

    Forms!frmName!ctlName.BackColor = 65535
    Me.Geek = True

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    That worked, thanks a lot! Josh

Posting Permissions

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