#Deleted after record deleted

[Guest]

I'm getting #Deleted in each field of my subform after I execute the record
delete code in visual basic. When I close the form and reopen it, the
#Deleted is gone. What do I need to do (or code to add) to NOT display the
#Deleted message in the record fields?

 

[Allen Browne]

Requery the subform after you execute the deletion, e.g.:

Forms![MyMain]![MySub].Form.Requery

 

[Guest]

Thanks!

Requery the subform after you execute the deletion, e.g.:

Forms![MyMain]![MySub].Form.Requery

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I'm getting #Deleted in each field of my subform after I execute the
record
delete code in visual basic. When I close the form and reopen it, the
#Deleted is gone. What do I need to do (or code to add) to NOT display
the
#Deleted message in the record fields?