Data Entry Restrictions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
Back
Top