Recent content by L15a5

I did read it. But to be totally honest. I didn't understand some of it. I haven't been using Access for that long. I know that at some stage it DID work properly. Unfortunately I didn't keep copies of the version I build. (A lesson learnt:rolleyes: ) I've decided that I'm going to rebuild the...

Don't worry, I've removed the inconsistant bit. The record source for the form I wish to allow edits on, is a query that uses data from two tables. The primary key is still present on all tables. However, I've found some records that are missing some data (fields which have a relationship in...

Hmmmmmm.... Well I'll keep trying to work it out. But if you have any suggestions as to why I cant update this info I'd really appreciate it. Thanks Lisa

Yes I did. However I think I may have stumbled across the answer. The "Recordset" property was set to "Dynaset" (whatever that is ???). I changed it to "Dynaset (inconsistant updates)" and now it seems to allow me to edit. It works, but I guess I could do with knowing what it means, as I...

Several records have been entered without one or two fields being completed. I have now discovered that users cannot go back to edit them in the forms. Although they can be edited in the database window (which I don’t want my users to do). Originally “Allow Edits, Deletions & Additions” were...

So what was the answer? As I have encountered the same problem. Lisa