Gray out entire form while pop-up form up?

P

Pamela

Is there a way to gray-out (or an equivalent action) an entire form w/ all of
its objects while/until the pop-up form is completed? I have found some
suggestions for doing this to individual objects on a form, but surely
there's a faster way to include everything...right?? Thanks so much!
 
B

Beetle

Why not just open the popup form in Dialog mode. That way the users
can't do anything until they are done with/close the popup form.

DoCmd.OpenForm "YourForm",,,,,acDialog
 
P

Pamela

I have it set that way now, but I'd like there to be a stark difference in
appearance showing that the underlying form is turned off, so to speak. Any
ideas? Thanks!
 
L

Linq Adams via AccessMonster.com

I agree with Sean's suggestion, but if you have to do it:


Dim ctrl As Control
For Each ctrl In Me.Controls
If (TypeOf ctrl Is TextBox) Or (TypeOf ctrl Is ComboBox) Then
ctrl.Enabled = False
End If
Next

To Enable them, just reverse it

ctrl.Enabled = True

Also, add other type of controls if need be. Just be sure that the type of
controls you use supports the property (Enabled, in this case) that you're
changing, or you'll get an error.
 
Top