How to link vbaMsgBoxHelpButton to a word file?

[James Bowyer]

I have written a lengthy training manual for an Access database I have created, and was wondering if it was possible to make a help button which is linked to it?

For example, if someone does not enter a value in a required field, a message box currently pops up to say "you must enter a value in this field", I would also then like there to be a Help option as well as the ok, which would open the training manual to the specific part which deals with this problem.

Hope this makes sense!

[pod]

what you want to do is within your error checking, insert a hyperlink call to your document immediately after your msgbox call

If (RequiredField is Empty) then
   msgbox ("you must enter a value in this field")
   Application.FollowHyperlink "C:\training-manual.doc"
End if