Stopping #deleted appearing on my form when I delete a complete record

I have a command button on one form (frmDelete) which deletes a record
from the subform (frmGrant) of a main form (frmCustomer) which is open
behind it. Problem is, when I go back to frmCustomer where the record
was deleted, every field in the subform contains the value #deleted.
How can I prevent this? I have tried adding the code:

Forms![frmClient]![frmInvoices].Form.Repaint

but it hasn't worked. can anyone help?

Try
Forms![frmClient]![frmInvoices].Form.Requery
Alex
"Jacko" <cloudbustingforever@hotmail.com> wrote in message
news:cfa69c85.0409200230.403aad15@posting.google.c om...[color=blue]
> I have a command button on one form (frmDelete) which deletes a record
> from the subform (frmGrant) of a main form (frmCustomer) which is open
> behind it. Problem is, when I go back to frmCustomer where the record
> was deleted, every field in the subform contains the value #deleted.
> How can I prevent this? I have tried adding the code:
>
> Forms![frmClient]![frmInvoices].Form.Repaint
>
> but it hasn't worked. can anyone help?[/color]