Re: Syntax for an open form

From: "Dave Ward" <dcward@xxxxxxxxxx>
Date: Mon, 8 Aug 2005 23:16:17 +1200

Perhaps this

If Not frmMyForm Is Nothing Then

"Ian Davies" <iandan.dav@xxxxxxxxxx> wrote in message
news:3E4Je.22341$Oe4.7754@xxxxxxxxxxxxxxxxxxxxxxx
> Hello
>
> I would like to include in a form load event the following
>
> Private Sub Form_Load()
>
> Dim SelSubject As String
>
> If [ACERTAIN FORM IS OPEN] Then
> SelSubject = "Like '%'"
> Else
> SelSubject = "=" & frmTests.cbdSubject.BoundText
> End If
>
>
> However, I cant find the syntax anywhere for the [ACERTAIN FORM IS OPEN]
> bit
>
> can anyone help?
>
> Thanks
> Ian
>
>

.

References:
- Syntax for an open form
  - From: Ian Davies

Prev by Date: Re: Column Width In MSHFlexGrid
Next by Date: Auto and uptodate deployment
Previous by thread: Re: Syntax for an open form
Next by thread: Re: lowest cost entry software?
Index(es):
- Date
- Thread

Relevant Pages

Re: Syntax for an open form
... >Private Sub Form_Load ... >Dim SelSubject As String ... I cant find the syntax anywhere for the [ACERTAIN FORM IS OPEN] bit ...
(microsoft.public.vb.general.discussion)
Re: Syntax for an open form
... > Private Sub Form_Load ... > Dim SelSubject As String ... I cant find the syntax anywhere for the [ACERTAIN FORM IS OPEN] ...
(microsoft.public.vb.general.discussion)
Re: Syntax for an open form
... > Private Sub Form_Load ... > Dim SelSubject As String ... > If [ACERTAIN FORM IS OPEN] Then ...
(microsoft.public.vb.general.discussion)
Syntax for an open form
... Private Sub Form_Load ... Dim SelSubject As String ... I cant find the syntax anywhere for the [ACERTAIN FORM IS OPEN] bit ...
(microsoft.public.vb.general.discussion)