In relation to the same problem, I have entered the code as above in to a "print" button of my form but when I clicked on the button, why am I still being prompted to enter the Primary Key? Why can't it pick up the Primary Key of the record I am viewing?
Hi Bill, thanks for the reminder. I corrected the typo error. I noticed that the report now does print the record that's being displayed. However, I still get a prompt to enter a primary key value. The funny thing is it does not matter what value that I enter but the record displayed will be printed. I could not identify what is prompting the input.
It beats me why do I have a different DOID and DO_ID. I am only using DOID for all my Primary Key field. The wierd thing is even when the prompt comes up, all I need to do is click on OK and the preview will come on correctly, even though I did not enter any value at all.
Thanks for the kind words. I have converted the DB to a "prior" version. I didn't get to select Access97 anywhere. I also did the compacting but to my amazement the DB actually got bigger after that. I managed to zipped it up though...but it's still a meg of file.