Subform refresh....

[cornishteeth]

I have a subform that runs off a query. Within that subform is a yes/no checkbox. What I want to achieve is when the checkbox is selected and put to "yes", the form is updated and the record is removed. I tried creating a macro that performs a requery "On Enter" when the checkbox was selected. Didn't work. Kept coming up with Apply Filter issues. Is there a way to do this. Where should I put the requery function. Under the entire form or the control source. Very limited to VB. Any help is appreciated.

Frank

 

[bat17]

I would do it on the Click event ou After Update event.
You may also find that you need to refer to the subform via the main form.
Forms![MainFormName]![SubFormName].Requery

HTH

Peter