Newbe Question: Reguarding Forms

[obliviux]

What is the command to call a form from an existing one?

I thought it was "ShowWindow" or "ShowForm" but these dont work.


thanks,

Jeremy [sig][/sig]

 

[BMeek]

Jeremy,
Try this code, but replace "NewForm" with the name of the form you want to show. This is usually used when a command button on the first form is clicked. (You can also call the routine anything you want, but I usally use a meaningful name)

Private Sub CmdShowNewForm_Click()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "NewForm"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_CmdShowNewForm_Click:
Exit Sub

End Sub

BMeek
[sig]<p>Bryan Meek<br><a href=mailto:bmeek@pacbell.net>bmeek@pacbell.net</a><br><a href=

http://www.handtech.com/meekent>Meek

Enterprises - Personal Technology Consultant</a><br>A TC in your corner gives you the personal attention you need to find the right technology solutions for your business.[/sig]