Results 1 to 2 of 2
  1. #1
    sparky23 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    9

    Smile Button On click change VBA code

    Hi,



    I need help to resolve one problem.
    My main form in Access has many drop down lists, Labels buttons etc.
    I need to sort them on two ways, one horizontal and one vertical.
    I already places two buttons that do this job form me, but the problem is, I want the last
    used sort to be opened next time when someone open the Access database.

    Is it possible to write some code that will change the code in Form_Load() sub.
    It's need only to update like "Call vertical or call horizontal" depends of the actual pressed button.

    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You'll need to save the value somewhere, typically a local table. On load, check that value and run the appropriate code.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 12
    Last Post: 07-15-2019, 06:33 PM
  2. Replies: 6
    Last Post: 11-10-2017, 05:00 PM
  3. Replies: 2
    Last Post: 09-21-2017, 05:34 AM
  4. Skip section of code on button click
    By NovoRapid in forum Modules
    Replies: 2
    Last Post: 02-05-2015, 02:43 PM
  5. Replies: 2
    Last Post: 10-09-2014, 11:37 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