How to create a button which closes the current form and then opens a new form

[Jacko7289]

Hi,
I've got a form (SearchForm1) which searches the student number using the surname, given name, date of birth. Once the student number is shown i want the user to click a button which will close the search form (SearchForm1) and then open the survey form (SurveyForm1).
In short i want a button which closes the current form (permanently) and opens another form at the same time.
Any suggetions is very much appreciated.
Cheers,
Jacko7289

[missinglinq]

This will do it. Create a button; when the Wizard comes up, hit Cancel. Now go into Properties - Events and click to the right of the OnClick Property. Click on the ellipsis (...).Click on Code Builder and enter this code:

Private Sub YourCommandButton_Click()
On Error GoTo Err_YourCommandButton_Click
 
    DoCmd.OpenForm "FormToOpen"
    DoCmd.Close acForm, "FormToClose"
 
Exit_YourCommandButton_Click:
    Exit Sub
 
Err_YourCommandButton_Click:
    MsgBox Err.Description
    Resume Exit_YourCommandButton_Click
 
End Sub

Welcome to TheScripts

Linq ;0)>

[damonreid]

Just make a new button that opens the new form using the critera you require using the button wizzard.

Then go into the VB for that button.

Add

DoCmd.Close

in the line before the open command is called.

[Jacko7289]

Thanks heaps, both solutions worked perfectly.
Cheers,
Jacko7289

[missinglinq]

Glad we could help!

Linq ;0)>