requery object - form

[pedro]

Hi,

I have created some code (an 'if' statement) on an 'on current' form event
so that when a checked box is checked, the visible property of an option
group is set to 'yes'. (so that the option group will appear when the check
box is clicked. This works okay, however I have to click back to the
preceeding record and then forward to the current record to refresh the form
so that the option group displays.

I would like to add some code to requery the form so that the option group
appears immediately after the check box is clicked.

thanks for your help.

 

[Douglas J. Steele]

You can simply call the form's Current event when you click on the check
box:

Private Sub MyCheckbox_Click()

Call Form_Current()

End Sub