Results 1 to 3 of 3
  1. #1
    wickedjc's Avatar
    wickedjc is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2016
    Posts
    3

    Smile Clear form

    I have database that I am taking over and need some help. On the Form there is a list of supplies that only shows up when the correct combo-box option has been chosen and that works just as it should however I cannot not seem to make that list go away afterwards. The clear form is taking all the combo boxes back to null but the lists remain, I need both the textboxes and labels to disappear on clear form function. As I said I am taking this over from someone and trying to figure out what has been done and so forth. Thanks ahead of time for any help!

  2. #2
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451
    not sure if you have figure this out. personally i do something similar with an entry form. if the clear form is happening as a afterupdate event just add a new line of code such as
    listboxname.visible=false
    labelname.visible=false

    just make sure that to turn it on when you need it as a afterupdate event of the combobox
    listboxname.visible=true
    labelname.visible=true

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    You want all or most of the labels and controls to become invisible after a user action occurs? How many are involved? If only a few, the example given will work fine (and if a label is attached to a control, the visibility of both are connected). If there are more than say, a dozen, a loop is neater code-wise. You also have the option to make these objects locked, which doesn't change their appearance, or disabled, which does. You cannot make a control invisible if it has the focus, so your code will have to ensure focus is on a control that will remain visible.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Clear Search Form
    By armyofdux in forum Forms
    Replies: 9
    Last Post: 03-03-2015, 06:24 AM
  2. clear form
    By slimjen in forum Forms
    Replies: 1
    Last Post: 05-16-2012, 02:53 PM
  3. Clear Form
    By hithere in forum Access
    Replies: 4
    Last Post: 03-28-2012, 09:28 AM
  4. How to clear form each time
    By JackieEVSC in forum Forms
    Replies: 1
    Last Post: 10-28-2011, 12:20 PM
  5. How to clear the form?
    By Mrcams in forum Access
    Replies: 3
    Last Post: 01-03-2011, 12:15 AM

Tags for this Thread

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