Command button in form to open certain files

[red7]

Hi,

I have based a form on a parameter query, so that when the user is prompted to enter a 'Hobby' to search on, the relevant records will be displayed on the form.

Now, I have created a command button designed to open a template letter in MS Word for a particular hobby. The problem is, I need the command to open certain file depending upon the value input in the parameter box intially. How would I go about doing this?

This may be very basic, or I may even be approaching this the wrong way, if so, any help is much appreciated

red.

 

[RichO]

You would want to have your user input their Hobby choice from a form. If you know what all of the possible choices are, use a combo box.

You would need to write a piece of code to look at their choice and open the appropriate file conditionally on the entry made.

You may want to delete your duplicate thread in the VBA/Modules section. Duplicate threads can cause confusion and the mods frown upon them.