Opening Forms

's Computer Specifications

Hi,

I have a problem. I need to open a form, edit some
properities and save, close it in code. I successfully
open the form using "docmd.openform <frmNameAsString>"
however I need the object in order to execute the
following command "form_frmName.form.property = true".
Sure I could hardcode the form names but I want to make
this a generic function. Any ideas???

's Computer Specifications

Hi,
You can refer to an open form like this:
Forms(frmNameAsString)

--
HTH
Dan Artuso, Access MVP

"Ian" <(E-Mail Removed)> wrote in message news:0a0c01c35034$bd2eaca0$(E-Mail Removed)...
> Hi,
>
> I have a problem. I need to open a form, edit some
> properities and save, close it in code. I successfully
> open the form using "docmd.openform <frmNameAsString>"
> however I need the object in order to execute the
> following command "form_frmName.form.property = true".
> Sure I could hardcode the form names but I want to make
> this a generic function. Any ideas???
>
>

's Computer Specifications

you are a LEGEND!! it works, ta muchly

>-----Original Message-----
>Hi,
>You can refer to an open form like this:
>Forms(frmNameAsString)
>
>--
>HTH
>Dan Artuso, Access MVP
>
>
>"Ian" <(E-Mail Removed)> wrote in message
news:0a0c01c35034$bd2eaca0$(E-Mail Removed)...
>> Hi,
>>
>> I have a problem. I need to open a form, edit some
>> properities and save, close it in code. I successfully
>> open the form using "docmd.openform <frmNameAsString>"
>> however I need the object in order to execute the
>> following command "form_frmName.form.property = true".
>> Sure I could hardcode the form names but I want to make
>> this a generic function. Any ideas???
>>
>>
>
>
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I have a million questions - forms, forms, forms	Cristy	Microsoft Outlook Form Programming	1	1st Oct 2008 06:41 PM
Windows Forms - Opening forms within forms	Dan Tallent	Microsoft C# .NET	20	27th Aug 2008 06:25 PM
Opening multiple forms and closing each one before opening the nex	=?Utf-8?B?TXVycmF5?=	Microsoft Access VBA Modules	1	26th Apr 2007 06:02 AM
opening different forms when opening database	=?Utf-8?B?RGFuaWVs?=	Microsoft Access Getting Started	8	25th Apr 2006 08:51 AM
Forms - Opening Mini Forms	The Boondock Saint	Microsoft Access	4	9th Apr 2006 10:14 AM