How to refresh a subform in datasheet view

[Paul]

A button on the main form to open a delete query to delete a record on a
table which used to populate the records on a subform in datasheet view. How
to refresh the datasheet view subform after the deleteion. Thanks.

 

[Reggie]

After you run the query on the button click event requery the subform.

Me.mysubformname.Requery

 

[Van T. Dinh]

In the CommandButton_Click Event, use something like:

{Your DELETE Query}
DoEvents
Me.SubformControl.Form.ReQuery

Note that the SubformControl name may be different from the name of the Form
being used as the Subform.