Errors on running Macros

[wllsth]

I'm not being allowed to run macros with the SET VALUE command because of the following
[CurrentProject].[IsTrusted] And Not ................

I believe I have set my Database to trusted, how do I check it. All my other VB code seems to work OK.

 

[wllsth]

Further info:-

I've copied some code from a Sample Database which allows you to run various reports from a drop-down combo-box. Although I get the drop-down list I cant get the macro to run.
I've also added some code from this Sample Database to allow users to Filter their data. I cant get this macro to run either.

Both these macros run OK directly from the Sample Database.

Any thoughts !!

 

[wllsth]

Problem solved.

I set the form to VIEW only and I was unable to use any other drop-down menus from the form thereafter.

I have had to alter my form design to suit