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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Can't edit record in subform datasheet view. 1
Force Autonumber to generate 0
Command Button with datasheet view 3
specifying which subdatasheet in Access 2003 3
Highlight rows in a subform datasheet view 0
Showing subform information in form (datasheet view) 1
Display Results from a select query in a subform 1

Back
Top