How to refresh a subform in datasheet view

  • Thread starter Thread starter Paul
  • Start date Start date
P

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.
 
After you run the query on the button click event requery the subform.

Me.mysubformname.Requery
 
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.
 
Back
Top