Results 1 to 3 of 3
  1. #1
    kreativ05 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2013
    Posts
    7

    Question Newbie in access 2007 need help with checkbox coding

    First Hi to all!!!...


    I am a complete newbie in Access 2007 so be patience with me. I am trying to do the following:

    I have a checkbox in the main form that once it is checked it enebles a textbox in a subform and calculates the sales tax, if it's unchecked the textbox is unabled and sets the value to zero...(so far I have managed to do this fine, after a few trial 'n errors), but here is my problem....when I navigate to the next record using a button that goes to the next record, it does not refresh/requery or whatever it needs to do to recheck if the checkbox is checked or not and do the action/event needed.

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Hi,
    I assume you have code working on the AfterUpdate of the control. What you need to do is add the same code to the OnCurrent of the main form.

  3. #3
    kreativ05 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2013
    Posts
    7
    Thanks...Yes, I had a working code in the AfterUpdate, but never thought in putting it in the onCurrent, I have just done it and it worked a treat

    Quote Originally Posted by SoftwareMatters View Post
    Hi,
    I assume you have code working on the AfterUpdate of the control. What you need to do is add the same code to the OnCurrent of the main form.
    Last edited by kreativ05; 01-22-2013 at 09:41 AM. Reason: chage of title

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

Similar Threads

  1. Help with access 2010 coding
    By framar in forum Access
    Replies: 5
    Last Post: 12-30-2012, 01:26 PM
  2. Need Help with Access vb coding
    By Entrimo in forum Access
    Replies: 1
    Last Post: 02-19-2012, 06:15 PM
  3. Access without coding
    By kp123 in forum Access
    Replies: 4
    Last Post: 11-25-2011, 03:50 PM
  4. Coding newbie
    By Phoenyxsgirl in forum Programming
    Replies: 2
    Last Post: 10-13-2011, 08:37 AM
  5. Replies: 2
    Last Post: 06-18-2011, 09:55 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