What is the recordsource of the main form? If it's a query (stored or
in-line SQL), what is the SQL of the query? Are you saying that if you open
that query as a datasheet, you can see the record in question, but it
doesn't appear on the form? Maybe the form has a Filter property that would
exclude the record, and Filter On Load is set to yes.
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html
(please reply to the newsgroup)