Data Entry Restrictions

J

JD McLeod

The first field in my form is box A, which is a combo box. Depending on the
item chosen in box A, the user would then need to proceed to either box B, C,
or D, which are all combo boxes as well. I would like to direct the user to
the appropriate box by "graying out" or locking the other two boxes. I have
done this once before, but can't quite remember how. Thanks.
 
J

John Vinson

The first field in my form is box A, which is a combo box. Depending on the
item chosen in box A, the user would then need to proceed to either box B, C,
or D, which are all combo boxes as well. I would like to direct the user to
the appropriate box by "graying out" or locking the other two boxes. I have
done this once before, but can't quite remember how. Thanks.
Click to expand...

Set the Enabled property of each such control, in *both* the
AfterUpdate event of the first combo, and also the Form's Current
event (so when the user moves to an existing record the choices are
appropriate).

John W. Vinson[MVP]
 
Top