A terrible thing I’ve just witnessed is that while I can seemingly add records thru my form, I cannot it seems update the pre-existing records using the form. I added a single date to a single field in a single record & my dbase just hung up. Meaning, when I tried to open the data entry form, access97 hung up. Any ideas? Thanks!

Try compacting and repairing your database. If that does not cure the problem create a new database and import everthing from the old database to the new one. If that does not work you may need to rebuild, from scratch, the form that is giving you trouble.

[This message has been edited by Jack Cowley (edited 05-30-2001).]

Wow, this really bites. I tried your advice Jack & compacting & importing to a new dbase is giving the same results. And here I thought I was going fine…sigh.

If making a new form does not cure your problem then I do not know where to tell you to go next... Hope that solves the problem, though!

Hope, my last salvation http://www.access-programmers.co.uk/ubb/smile.gif

This is kind of a dumb question, but is your allowedits property set to yes?

yup

Another dumb question have you tried re-starting windows?

Yeah, well i did when my access97 help files wouldn't respond so i restarted my computer at that time, just before i realized the problem i mentioned above. Maybe i can try again & let you know. Currently i'm going thru & examining vba that would set cancel=true and not allow the save of a record & see if screwed up something in there.