Refreshing subform

[access83]

Hi All,

I'm having a problem getting a subform (continuous form) refreshed to remove items that have been deleted. It works fine when there is more than one item in the list, however, when I delete the last item in the form it is still displayed. The only way for it to no longer be displayed is click on another tab on the form and then click back to the tab with the subform and the item that was deleted is finally removed from the subform. I have tried using '.requery' but that doesn't work either.

Has anyone had this problem before?

Thanks in advance

 

[mdlueck]

So the subform multiple records list refreshes for deletion of the 3rd and 2nd record, just not the last record?

I have tried using '.requery' but that doesn't work either.

Are you certain that the subform control is the control which the event is being sent to?

From my main forms which have multiple items subforms on them, I send the requery request event to the form in the subform control and have that form requery itself.

  'Call the subform's Requery_Click Events
  Call subform_quality.Form.Requery_Click