Results 1 to 2 of 2

Case Select using command buttons

  1. #1
    NickWren is offline Advanced Beginner
    Windows XP Access 2013
    Join Date
    Dec 2015
    Location
    Connecticut
    Posts
    70

    Case Select using command buttons

    I need a case select depending on what button/textboxes are enabled

    button 1: BloodProcessButton
    Me.BloodProcessButton.Enable = True


    Me.BloodProcess = True
    Me.DateBloodProcess = Date

    button 2: RNAQButton
    Me.RNAQButton.Enable = True
    Me.RNAQuantification = True
    Me.DateRNAQ = Date

    button 3: ...
    so on.

    So really I need the case to use whether these text fields are enabled or disabled, if enabled then put the date and check off that the process was done

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    why not just have an on click event for your checkboxes, I'm assuming these are checkboxes because you're checking for a TRUE value

    You could simply have in the ON CLICK event of (for instance) BLOODPROCESS

    if BLOODPROCESS = -1 then DATEBLOODPROCESS = date else DATEBLOODPROCESS = null

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

Similar Threads

  1. Pl sql case select
    By mrmmickle1 in forum Queries
    Replies: 1
    Last Post: 11-17-2015, 11:14 PM
  2. Select Case Error
    By LaughingBull in forum Access
    Replies: 13
    Last Post: 09-11-2015, 02:05 PM
  3. Select case help
    By killermonkey in forum Programming
    Replies: 7
    Last Post: 10-25-2013, 05:09 PM
  4. VBA for SELECT CASE logic
    By rlsublime in forum Programming
    Replies: 1
    Last Post: 12-04-2012, 09:09 PM
  5. Replies: 2
    Last Post: 03-25-2010, 12:11 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
  •  
Tech Forums: Microsoft Office Forums