Hi.
Most likely, all of the fields on the form are marked #Deleted because the
record that the form is trying to access has been deleted by another process,
or in a multiuser database, deleted by another user. Whenever you open a
bound form, the database creates a record set from the record source, which
is subject to change. In your case, a record has been deleted, so it can no
longer be accessed in the current record set.
This record will continue to be referenced by the current record set until
the current record set is replaced with another record set. To do this,
either requery the form or close, then open the form again. If you continue
to experience the #Deleted fields every time you open the form, then you have
some problem with your database, such as corruption, and you need to find out
why a record that is supposed to be displayed has already been deleted or is
claiming to be deleted. If this is the case, look for bound Memo fields,
because this has been known to cause corruption.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
