Results 1 to 4 of 4
  1. #1
    sgross is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2017
    Posts
    2

    Form Caption to Read Field Entry

    I am trying to get my form caption to reflect a field that is entered on that form. Is that possible? For example, if my Field is Location I would like the form Caption to reflect the location selected from the dropdown menu once saved. I have many forms open at once as I am using this as an active call log and it gets confusing without a better Form Caption system. Thanks for any help

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,523
    Code:
    sub txtLocation_afterupdate()
    me.caption = txtLocation
    end sub

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,469
    To expand abit more, maybe do on form AfterUpdate and also can do on form OnCurrent if you are scrolling through records.

    Me.Caption = Nz(Me.ItemDes, "..")

  4. #4
    sgross is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2017
    Posts
    2
    Thanks!! This worked great!!

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

Similar Threads

  1. Replies: 3
    Last Post: 07-13-2016, 08:21 PM
  2. Replies: 15
    Last Post: 11-03-2015, 12:48 AM
  3. Read only field on Split form
    By casinc815 in forum Forms
    Replies: 1
    Last Post: 04-26-2014, 02:51 PM
  4. Replies: 2
    Last Post: 07-30-2013, 11:53 AM
  5. Set Label.Caption to field of recordsource
    By ngruson in forum Forms
    Replies: 1
    Last Post: 08-11-2010, 09:59 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