Are there ways to create various interactive buttons using vba on forms

[wedd]

Is there a way I can code using vba to take the user to different forms when clicking on a button, without having to click a next or back button on the standardised wizard options in access 2007? If so, how can this be done? I have a few buttons on a form and i would like when a user clicks on each button it takes the user to different forms or sections without clicking the next button options....


Thanks:friends:

[orange]

Here is a link with a simple approach. Call the function using the name of the form you want to open, using the OnClick event of the button.
Good luck.

http://accesstips.wordpress.com/2007/06/25/how-to-open-forms-with-a-simple-function-that-saves-you-time-and-work/