Results 1 to 6 of 6
  1. #1
    KellyCarter is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Mooresville, NC
    Posts
    3

    Combo Box Visible property not available in coding of Event


    Private Sub Combo155_AfterUpdate()
    If Me.Q9 = "No" Then

    Me.Q9Dropdown.Visible = True
    Me.Label813.Visible = True
    Else
    Me.Q9Dropdown.Visible = False
    Me.Label813.Visible = False
    Exit Sub
    End If
    End Sub

    I'm getting an error (see attachment) on the bolded line. It appears the only property available to me is "value". I have another set of fields doing the same thing and it works perfectly but I can't get the rest to work and recognize the "visible" property. Any guidance would be appreciated! Thanks so much!
    Attached Thumbnails Attached Thumbnails Access Issue.jpg  

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you have a control named "Q9Dropdown? What kind of control is it?

  3. #3
    KellyCarter is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Mooresville, NC
    Posts
    3
    Yes. It's a combo box.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    AFAIK there are 3 reasons to get this error. 1) Q9Dropdown control does not exist or is misspelled, 2) Q9Dropdown is duplicated somewhere in your system, 3) Corruption. For the corruption you could try *importing* your db into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

  5. #5
    KellyCarter is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Mooresville, NC
    Posts
    3

    Smile

    Nothing like a new day to find a fresh perspective. I found my mistake. When I added the field, I put the control source in but didn't change the name to Q9Dropdown so the coding I added didn't know what field I was talking about. All fixed now!

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! Thanks for posting back with your success and solution.

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

Similar Threads

  1. Replies: 5
    Last Post: 01-28-2013, 11:52 AM
  2. Replies: 6
    Last Post: 09-27-2011, 04:39 PM
  3. Setting visible property of subreport?
    By GaryElwood in forum Reports
    Replies: 1
    Last Post: 09-23-2011, 07:49 PM
  4. Visible property in subform columns
    By MDB in forum Forms
    Replies: 3
    Last Post: 09-03-2011, 06:46 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