Cheers David,
Yes, I was not saving the record and that was causing the confusion.
The code above was for the "add" cmd button. Just stuck "DoCmd.RunCommand acCmdSaveRecord" at the start of it and it starts working :-)
Cheers - might put it somewhere else in the form, but good for now...
Hello,
This is my first post here. I tend not to post as I usually find the answers i need from other posts or work it out. I have got to a point where I am struggling with an issue.
I am not a great database programmer - did it about 15 years ago at school and picking up now to create a DB...