Results 1 to 5 of 5
  1. #1
    AccessThomas is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    26

    Split Form visible field issue

    I have a split form in Access 2013. I have a checkbox in the top frame that if checked a textbox becomes visible. However, if I click on a different record and check the box and go back to the previous record, the textbox becomes invisible even though the checkbox is checked.

    My code for the checkbox is
    Private Sub chkPhoneChange_Click()
    If chkPhoneChange.Value = True Then
    lblNewPhoneNumber.Visible = True
    txtUpdatedNumber.Visible = True
    Else: If chkPhoneChange.Value = False Then lblNewPhoneNumber.Visible = False
    txtUpdatedNumber.Visible = False


    txtUpdatedNumber.Value = ""
    End If

    Any ideas?

    Thanks.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Try changing the visibility of the txtBox in the Form_Current() event.

  3. #3
    AccessThomas is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    26
    Excuse the ignorance but where is the form_current() event?

    Thanks.

  4. #4
    AccessThomas is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    26
    Never mind. I found it, thanks.

  5. #5
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Glad you found it =).

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

Similar Threads

  1. Replies: 16
    Last Post: 03-26-2015, 08:35 PM
  2. Replies: 4
    Last Post: 11-04-2014, 07:35 PM
  3. Replies: 22
    Last Post: 05-21-2013, 07:54 PM
  4. Replies: 2
    Last Post: 04-04-2011, 02:18 PM
  5. Replies: 2
    Last Post: 01-06-2011, 04:38 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