Results 1 to 2 of 2
  1. #1
    ALEXIS MAGTOTO MORTEL is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2020
    Posts
    1

    Post Working with sub form

    I am a beginner in microsoft access. I am creating a database with one main form and three subform. My subform is in datasheet view.
    I want the out put can be see is if i click a command botton the subform i set as visible is seen in the main form. If I next record i want
    the subform is set visible to false. I am using a Macro set property to command visible if true or false.
    I am setting this command in form property sheet to On load and after update property.

    the code of macro is

    SetProperty

    Control name :formname
    Property Visible
    Value False


    I am using this code to On load and After update property.
    I use a command button the same command but the value is true.

    this code is not working. Please kindly help me in this matter

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is name of the subform container control? Need to set property of container. If container has same name as form it holds, code should work.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 28
    Last Post: 01-24-2018, 05:14 PM
  2. Replies: 13
    Last Post: 01-22-2015, 05:27 PM
  3. Replies: 8
    Last Post: 01-13-2015, 12:23 PM
  4. Replies: 2
    Last Post: 03-21-2012, 10:36 AM
  5. Replies: 2
    Last Post: 08-18-2011, 10:20 PM

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