AGGHHH I must be overlooking something "#Delete"

[ShanePresley]

I added a subform and now when I open the parent form most of the records in the subform show #Delete as the values!! The row count seems to match but I can't see the data. It must be something obvious that I am missing. It's been a while since I looked at this stuff, I must have forgotten alot.

Any help is appreciated. If someone could just steer me in a direction, that would be great!

Thanks,
Shane

 

[ChrisUK]

Re: AGGHHH I must be overlooking something "#Delete&quo

It would be useful to show us some code, without it we can't help!

 

[SydneyGeek]

Re: AGGHHH I must be overlooking something "#Delete&quo

Sounds like you may have database corruption issues. #Deleted showing up in your forms is one of the symptoms. Try Tools | Database Utilities | Compact and Repair Database, to see if that fixes the problam. (If you use Access 97, Compact and Repair are 2 separate commands; in later versions they are one command)

Denis