#Deleted

[aziz rasul]

Hi,

On the OnCurrent event of a form, some or all records are deleted. The combo boxes show #Deleted. Is there a way that refreshes the form so that these don't appear?

 

[deville75]

I'm not exactly sure what you're talking about. Can you explain in more detail?

 

[boblarson]

That can happen if someone else deletes a record and when you go to it (since your recordset still thinks it's still there) it will show #Deleted, or it can also happen if you delete a record, or records, while in different form and then come back to the other form.

To get around this, you can requery the form.

 

[aziz rasul]

I'll try requerying the form. Thanks.