Results 1 to 2 of 2
  1. #1
    Obidombie is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2016
    Posts
    1

    Code writing


    I have designed a form, in the form I have a field called "Previous School? and have Yes and No as responds in the combo box. Now, I want it in such a way that when the answer is 'No' the next question should be blocked. eg. ( Any previous school? Yes....if yes Name of school. So if the answer is No the provide name of the school should be blocked.
    Any help?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have an invisible text box ,txtPrevSchool.
    when the user picks the combo,

    Code:
    sub cboPrev_afterupdate()
       txtPrevSchool.visible = lcase(cboPrev) = "yes"
    end sub

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

Similar Threads

  1. Help Writing Date Change SQL Code
    By McArthurGDM in forum Programming
    Replies: 4
    Last Post: 06-30-2015, 01:36 PM
  2. help writing code that will update a table
    By 24t42 in forum Programming
    Replies: 1
    Last Post: 02-18-2015, 08:21 PM
  3. Replies: 4
    Last Post: 12-09-2014, 02:01 AM
  4. Writing Code for "After Update" Table Events
    By dipique in forum Programming
    Replies: 10
    Last Post: 07-09-2012, 08:11 AM
  5. Writing code on the fly - TransferSpreadsheet
    By IanT in forum Import/Export Data
    Replies: 1
    Last Post: 05-24-2012, 08:28 AM

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