Unanswered: Trouble creating code to find contacts files
I have converted an Access 2000 database I wrote a while ago. There is a form in there that finds all files held in a specified folder that relates to the contact whose record is open -files are found by the fact that all related files start with the FirstName field, and include pdfs, doc, excel etc...
At this point I always get the reply "there are no files to be found for contact x" even though I know that there are...
I have attached a copy of the code here - if anyone can help me please pinpioint where my code is breaking down it would be very much appreciated!
Thanks - but it didn't change anything..
I have found a work around though - it qorks as long as individual files aren't kept in a further sub-folder... so (while a bit messier when just look via Explorer) I can jsut keep all my files in one big folder and Access will find them from there.
Thank you for your efforts though