Hello,
I have a form (Access 2003) which brings up a clients details on screen (name, phone number, etc etc), so that an end-user can modify any of these clients details, and save the updates. Also however on this form is a button, that says "notes", which, in theory, when you click on it, opens up a word (word 2003) file with notes, pictures, text etc etc, all about that particular client
What I need help with is.......say the end-user has freddy jones' record up, open, on screen, and clicks on "notes". I need access to then open the "fredy jones.doc" file.......or it may be mary jones' record that is open, so thus access has to open "mary jones.doc". The (primary key) field in the form that contains the clients name is entitled "clientname".I dont know to get access to look at the data / value in the "clientnme" field, and then say.....okay, yep, i want to open the corresponding word file, whose *.doc name is the same as the data/value in the "clientname" field
Thanking you in advance,
Jeff