Prev: Form Field/Function problem
Next: Protecting text boxes in forms
From: Chad on 12 Apr 2010 10:56
Is there a way to have a form that is already open switch its window mode
from Normal to Dialog?

Thanks,
Chad
From: Jon Lewis on 12 Apr 2010 11:16
What do you want the effect of this to be?

Jon


"Chad" <Chad(a)discussions.microsoft.com> wrote in message
news:73E13434-2FCC-4C15-B92F-5AB78D10E48D(a)microsoft.com...
> Is there a way to have a form that is already open switch its window mode
> from Normal to Dialog?
>
> Thanks,
> Chad


From: Chad on 12 Apr 2010 12:02
I have a form that opens depending on whether a specific selection is made in
a combo box in another form. I would like to be able to run a line of code
in the On Change event of that combo box after this new form is open, but do
not want the user to be able to do anything else unless they close this new
form (hence the dialog window mode).

Any suggestions would be appreciated.

Thanks!

"Jon Lewis" wrote:

> What do you want the effect of this to be?
>
> Jon
>
>
> "Chad" <Chad(a)discussions.microsoft.com> wrote in message
> news:73E13434-2FCC-4C15-B92F-5AB78D10E48D(a)microsoft.com...
> > Is there a way to have a form that is already open switch its window mode
> > from Normal to Dialog?
> >
> > Thanks,
> > Chad
>
>
> .
>
From: Jon Lewis on 12 Apr 2010 13:36
You can get some 'Modularity' by using Forms!YourForm.Modal = True but not
the same as opening the Form acDialog. What you want can probably done
using Windows API functions but I would not recommend it as turning a
non-dialog form into a dialog is just not normal program flow.

HTH

"Chad" <Chad(a)discussions.microsoft.com> wrote in message
news:2281A06D-7C67-4564-9FC8-E143568372B1(a)microsoft.com...
>I have a form that opens depending on whether a specific selection is made
>in
> a combo box in another form. I would like to be able to run a line of
> code
> in the On Change event of that combo box after this new form is open, but
> do
> not want the user to be able to do anything else unless they close this
> new
> form (hence the dialog window mode).
>
> Any suggestions would be appreciated.
>
> Thanks!
>
> "Jon Lewis" wrote:
>
>> What do you want the effect of this to be?
>>
>> Jon
>>
>>
>> "Chad" <Chad(a)discussions.microsoft.com> wrote in message
>> news:73E13434-2FCC-4C15-B92F-5AB78D10E48D(a)microsoft.com...
>> > Is there a way to have a form that is already open switch its window
>> > mode
>> > from Normal to Dialog?
>> >
>> > Thanks,
>> > Chad
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Form Field/Function problem
Next: Protecting text boxes in forms