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

how to prevent getting #Deleting in a form if we delete saved records

P: 115
Hi i have a form that contain a subform.
when i delete the information that i already inserted in the subform, i got #Deleted in every text boxe. what can i do to prevent this?
Aug 10 '10 #1
Share this Question
Share on Google+
2 Replies

P: 119
This is the normal behavior for Access. I think you can still add Refresh command to the delete button so that the user can't notice #Deleted.

Expand|Select|Wrap|Line Numbers
  1. Me.Refresh
Hope this helps,
Aug 22 '10 #2

Expert 2.5K+
P: 3,532
Per Access Help, Refresh only shows changes made to current records in a multi-user environment. It will not show/exclude records that have been added/deleted. For this you have to actually Requery the RecordSet using Me.Requery.

Linq ;0)>
Aug 22 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.