#Deleted after record deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Requery the subform after you execute the deletion, e.g.:

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

Allen Browne said:
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.

redrover said:
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?
Click to expand...
Click to expand...
 
Back
Top