Newbie in access 2007 need help with checkbox coding

[kreativ05]

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.

[SoftwareMatters]

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.

[kreativ05]

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

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.