How to open form in a same window

[sanchez]

Hello this might be an old question..
i have a database with all form's properties turn into Pop Up form..
my situation is, lets say, the main form is the Personal info of my students, then when I click the Open Form comand button, which is suppose to open another form let say Guidance form (in pop up form as well) but, i need that form to be open in that same window, not overlapping the previous form..


Thanks for helping.

[RuralGuy]

How about setting the Personal Info form invisible until the user closes the Guidance form?

[sanchez]

oh how to do that.?
by the way i'm a beginner and glad to learn more

[RuralGuy]

What do you have in the Open Form command button?

[sanchez]

I'm not really sure..i only pick up that button from Design Tab and follow the wizard..

well if u see that picture that i've attached, thats is my problem..I dont want the 1st form still there when i click the Open Form Buttons..

[RuralGuy]

With the 1st form in Design view, right click on the OpenForm button and display the properties sheet. On the Event tab under the Click event, click the "..." button and what do you see?

[sanchez]

looks like this..they used embbeded macro..

[RuralGuy]

If you could convert it to code, I could show you how to change it. It is under the Design tab when you have the form open in design view.

[sanchez]

'------------------------------------------------------------
' cmdOpen_Click
'
'------------------------------------------------------------
Private Sub cmdOpen_Click()
On Error GoTo cmdOpen_Click_Err

' _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?>
' <UserInterfaceMacro For="Command58" xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><Statements><Action Name="OpenForm"><Argument Name="FormName">frmNewPelajar<
' _AXL:/Argument></Action></Statements></UserInterfaceMacro>
Docmd.OpenForm "frmBiodataPelajar2", acNormal, "", "[NamaPelajar]=" &" '" [&NamaPelajar] & "'", , acNormal


cmdOpen_Click_Exit:
Exit Sub

cmdOpen_Click_Err:
MsgBox Error$
Resume cmdOpen_Click_Exit

End Sub

[RuralGuy]

Use this code in the event:

'------------------------------------------------------------
' cmdOpen_Click
'
'------------------------------------------------------------
Private Sub cmdOpen_Click()
   On Error GoTo cmdOpen_Click_Err
   Me.Visible = False
   DoCmd.OpenForm "frmBiodataPelajar2", , , "[NamaPelajar]= '" & [&NamaPelajar] & "'", , , acDialog
   Me.Visible = True
cmdOpen_Click_Exit:
   Exit Sub
cmdOpen_Click_Err:
   MsgBox Error$
   Resume cmdOpen_Click_Exit
End Sub

[sanchez]

Thanx for your helps RuralGuy..

[RuralGuy]

Glad I could help.