Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by BrunoAlbuquerque.jur View Post
    Ok, the problem is that when I pass through the clients it does not auto run in order to see only what is suppose to
    Instead of the load event, use the current event, which fires on load and on the changing of records. Instead of having all that code in 2 places, I'd create a function and call it from both places.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #32
    Join Date
    Nov 2019
    Posts
    21
    Quote Originally Posted by pbaldy View Post
    Not sure what you mean. The "Else" code is executing, you just have to make sure you set every control's visibility as desired. If something was visible for the first selection, it won't hide for the second selection unless you tell it to.

    Click image for larger version. 

Name:	through clients.png 
Views:	10 
Size:	31.6 KB 
ID:	40330

    Is it possible to auto show and hide what I want when I click the indicated arrows?

    Because right now what happens is that it has to be manually selected, every time, the type of person person that is to be selected to show the right data.

  3. #33
    Join Date
    Nov 2019
    Posts
    21
    Quote Originally Posted by pbaldy View Post
    Instead of the load event, use the current event, which fires on load and on the changing of records. Instead of having all that code in 2 places, I'd create a function and call it from both places.

    Solved!! Fantastic! With much less code.

  4. #34
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by BrunoAlbuquerque.jur View Post
    Is it possible to auto show and hide what I want when I click the indicated arrows?

    Because right now what happens is that it has to be manually selected, every time, the type of person person that is to be selected to show the right data.
    See post 31.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #35
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by BrunoAlbuquerque.jur View Post
    Solved!! Fantastic! With much less code.
    Excellent! Glad you got it working.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #36
    Join Date
    Nov 2019
    Posts
    21
    We did! Thank you for your patience.

  7. #37
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-18-2015, 09:37 PM
  2. Replies: 3
    Last Post: 01-31-2015, 07:24 PM
  3. Replies: 9
    Last Post: 11-01-2013, 11:56 AM
  4. Replies: 11
    Last Post: 10-12-2012, 08:37 AM
  5. IIF statement based on check box returns #error
    By timmygrover in forum Queries
    Replies: 7
    Last Post: 09-04-2012, 04:41 PM

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