VBA or Expression Builder for using toggle button to open a page

[mckg15]

Hi newish to Access and am just starting to try to dabble in VBA, Macros, Expression Builders to make my database forms cleaner and more user friendly. I have tried searching several sites and have been unable to find anything helpful to guide me in how to write the VBA code or use Expression Builder. I get error messages with everything I put in.

My goal right now is to use option group toggle buttons to direct the user to specific pages once pressed. Have been unable to figure out how to do this. Can anyone point me to a good resource or tell me what I need to enter to make this work? Also open to other means to achieve this.

Thanks in advance!

 

[xenou]

A toggle button is a yes/no control so I wouldn't advise using it for this purpose. A normal button would be sufficient to do any action that needs to occur on a press event (aka click event). I'm not sure what you mean by a page - you'll have to find out how to open or activate that type of object, whatever it is.

I'd advise not to use the expression builder. Too confusing for newbies and completely unnecessary for non-newbies.

 

[Micron]

My goal right now is to use option group toggle buttons

An option group typically contains option buttons aka radio buttons, and will allow you to deal with one choice out of many as you seem to want to do. Calling them toggle buttons may confuse because that is a different control that doesn't really have any use as a grouped control. You may be having issues re the builder because of not knowing how they work?

Each option button in a group needs to have a distinct value. When chosen, that value gets passed to the frame, so it is the frame value that you look for to see which was chosen. Option buttons must be added to a group correctly while in design view, otherwise they can end up looking like they are part of the frame group but they are just sitting in that area of the form.