Auto close, Auto Open

  • Thread starter Thread starter Joyce O
  • Start date Start date
J

Joyce O

I remember once seeing some code that when a command
button was clicked on a form, to open another form, the
form with the button would close and the form lauched by
clicking the button would open. What is the code to make
the current form in view close when another form is
opened. As always I appriciate your help.

Oh, also, is there a property to make the form open in
full screen size or is that accomplished with VBA code?
 
Private Sub MainFormName_Click()
DoCmd.Close acForm, "MainFormName"
DoCmd.OpenForm "SecondFormName"
End Sub



I remember once seeing some code that when a command
button was clicked on a form, to open another form, the
form with the button would close and the form lauched by
clicking the button would open. What is the code to make
the current form in view close when another form is
opened. As always I appriciate your help.

Oh, also, is there a property to make the form open in
full screen size or is that accomplished with VBA code?
 
I am also interested in knowing if there is a way to open a form in full
screen programatically. I have a form that I want to to use as the main
screen in a DB with other forms opened with pop-up, modal, and dialog set to
yes. The main form is not staying full screen.

Best regards,
Scott B
 
Back
Top