Errors on running Macros

[willsth]

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.

PS I'm using Access 2007

 

[willsth]

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 !!

 

[willsth]

Problem solved I had set my Form to Read-only therefore I couldnt access any drop-down options from my form.

I have had to rethink my Form Design