Results 1 to 6 of 6
  1. #1
    elibleki is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3

    unhide controls

    Hi to all,
    I'm new in this forume and maybe I'm making thing wrongly.
    My problem is this.
    I would like to post an hiden or invisible controle in a form, but I would like to unhide ore make Visible this control, if I check a box or beter if I put a certain value (e.g. Yes) in another control.
    when I say "Yes" to a control, it unhided desired control, but, the problem is that It must work only for current record not for all records!
    thanks in advance
    Eli

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    What event are you putting the code on. Afterupdate for a control? or is it for an event triggered by the form. Perhaps if you showed us the code and tells us what triggers it, we might be able to be more helpful.

  3. #3
    elibleki is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3

    unhide/hide only current controls

    I've put a code like this

    Private Sub insulation_Click()
    If Me.insulation = "Yes" Then
    depth.Visible = True
    Else
    depth.Visible = False
    End If
    End Sub
    thanks in advance
    Eli

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I think that you need to have it in the afterupdate event for insulation and not on the click event. You probably also want to have an onload event for the form that says it is not visible when opening the form.

  5. #5
    elibleki is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    3
    dear Mr. Alan Sidman
    Your answer helped me so much. Even not on the way I could like, it works. So, my problem is solved, but, I don't know where to say that my problem is solved. Or where to mark my problem as solved.
    best wishes
    eli

  6. #6
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In your original thread, click on thread tools.

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

Similar Threads

  1. Unhide what I've hidden
    By wwm in forum Access
    Replies: 2
    Last Post: 09-20-2022, 02:32 PM
  2. Unhide key field
    By tss in forum Forms
    Replies: 1
    Last Post: 11-03-2011, 09:37 PM
  3. Windowhide/Unhide
    By andrewbaja in forum Access
    Replies: 5
    Last Post: 06-20-2011, 03:45 PM
  4. need to unhide my top menu bar
    By techexpressinc in forum Forms
    Replies: 1
    Last Post: 06-08-2010, 07:05 AM
  5. Unhide Hidden Query
    By Valeda in forum Queries
    Replies: 2
    Last Post: 05-12-2006, 05:58 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