Results 1 to 2 of 2
  1. #1
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    referencing a field attribute or is dirty


    I want to take an action if a certain field is dirty. What would that look like?

    or if Me.[field].BackColor = RGB(252, 230, 212) Then do this....

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Code:
    sub txtBox1_afterupdate()
    
    
    if Me.txtBox1.BackColor = RGB(252, 230, 212) Then msgbox "new data entered" endif end sub

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

Similar Threads

  1. Referencing a Report Field with VBA
    By Lorlai in forum Programming
    Replies: 13
    Last Post: 03-26-2013, 09:53 AM
  2. Referencing Field Names
    By andy-29 in forum Access
    Replies: 6
    Last Post: 11-20-2012, 03:27 PM
  3. On Dirty fires but Me.Dirty = False (v2010)
    By Rod in forum Programming
    Replies: 5
    Last Post: 07-30-2011, 08:42 PM
  4. Referencing a query field
    By rcrobman in forum Queries
    Replies: 5
    Last Post: 04-29-2011, 04:06 PM
  5. Referencing A Form Field In A Report
    By CGM3 in forum Reports
    Replies: 5
    Last Post: 07-01-2010, 08:16 PM

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