a button with 2 functions

[simeon_rose]

can anybody help me? i need to create a button for a form that closes that form and opens another at the same time...kinda like a 'submit' button that takes you to the next page where you can fill in more tables. there'e no wizard for opening and closing forms at the same time but i've looked at the two individual functions' code, but can't quite figure out how to combine them into one section of code and then asign this to a button. i hope i've made myself clear...if i haven't, then you've probably got just about as much of a clue as to what i'm on about as i have! help me please...

 

[Jack Cowley]

Put this code in the On Click event of the Command Button....

DoCmd.OpenForm "NameOfFormYouWantToOpen"
DoCmd.Close, acForm, "NameOfFormYouWantToClose"

[This message has been edited by Jack Cowley (edited 11-05-2000).]