By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try
Forms![frmClient]![frmInvoices].Form.Requery
Alex
"Jacko" <cl*****************@hotmail.com> wrote in message
news:cf**************************@posting.google.c om...
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.