Using a Button to activate a Check Box

[gunny3000]

Hi,

I'm terrible now at VB... I think I've lost my marbles getting old!

I have tried the following to "activate" a Check Box using a Button...


Private Sub Command270_Click()

Me.Print_Mark.Value = True

End Sub


I need help please.

 

[RuralGuy]

If you mean by "Activate" to enable then you want:
Me.Print_Mark.Enabled = True

 

[gunny3000]

thanks but I must mean 'checked'

 

[RuralGuy]

In that case I do not see why what you had didn't work. Did you spell the name of the control correctly? After you typed in the period "." did intellisense pop up and show you your choices?

 

[John Big Booty]

The check box is on the same form as the button and not on a sub-form?

 

[gunny3000]

RG, Yes, the auto intellisense pop-up comes up with my selection as a choice.

I also like to leave the uppercases off on purpose and watch them change when i press enter...

John, Yes, the Command Button and CheckBox are on the same Form.



this is a strange one!

 

[John Big Booty]

I would have just settled for;

Me.Print_Mark = True

But I've just check in my sandbox DB and

Me.Print_Mark.Value = True

Works equally as well

 

[Marinus]

Newer than New is what you can call me, I have a working one on my form, please follow the kink..

http://www.access-programmers.co.uk/forums/showthread.php?t=202249

Hope that will help..

 

[gunny3000]

Is there a global setting in Access 2007 I should know about?

 

[John Big Booty]

Does other code run correctly in this DB?

 

[John Big Booty]

Is there a global setting in Access 2007 I should know about?

Have a look at your Trust Centre settings.

 

[gunny3000]

Hi, I don't have a lot of code, but, I have all the Form and Report standard Command Buttons that I created from the Wizard. They all work fine to be fair.

 

[RuralGuy]

You have set your Trusted Location, right?

 

[gunny3000]

RG, I have to admit that I have never done this and don't know how... any pointers? (you're dealing with a novice by the way)

 

[RuralGuy]

No problem. Here it is in pictures: http://www.btabdevelopment.com/ts/default.aspx?PageId=13

 

[gunny3000]

SORTED!.... Thanks, you're all legends.

 

[RuralGuy]

Excellent Gunny! Thanks for posting back with your success.