how to open a subform within a main form using a button...

[ssr61]

hi

can u help me how to open a sub form with in a main form
without opening a new window.....

my main form (frm_searchby_Name)consists
of text field to enter the address and button

when i click the button a new subform window is opening...

can i open in the main form itself?

thank u
ssr

Private Sub Command20_Click()
On Error GoTo Err_Command20_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "sfrm_searchby_Name"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Exit_Command20_Click:
    Exit Sub
 
Err_Command20_Click:
    MsgBox Err.Description
    Resume Exit_Command20_Click
 
End Sub
 

[nico5038]

For this you can place a subform on the mainform using the subform wizard from the toolbox.
Using the right-click popup menu the "search" you're performing now can be achieved without coding, check:
http://www.geocities.com/nico5038/xR...nstruction.zip

Nic;o)