PREVENTING USERS FROM MESSING UP

  • Thread starter Thread starter JOE
  • Start date Start date
J

JOE

HEY THERE I AM TRYING TO FIGURE OUT HOW TO PREVENT SOMEONE
FROM ENTERING DATA TO MY SUBFORM WITHOUT THEM FIRST
PICKING A CATEGORY THAT THEY ARE GOING TO WANT THE
INFORMATION TO BE IN. HOW DO I PREVENT THE POSSIBILITY OF
THIS HAPPENING.


I AM DOING A INVENTORY MY SUBFORM HAS ALL MY PART NUMBER
INFO AND ALL THE INFORMATION NECESSARY FOR THAT PART. AND
THERE ARE 14 CATEGORIES THEY COULD FALL IN.

THANKS
 
Step 1 : Check the Caps Lock. <g>

Step 2: De-activate the subform and only activate it after the user picks a
category.
 
Hi Joe,

PLEASE DON'T SHOUT. It makes your message much harder to understand.

One way of doing this sort of thing is to put code in the subform's
Current event procedure that looks at the contents of the control where
users pick the category. If there's no category there, set the .Enabled
(or perhaps .Locked) property of the other controls on the subform to
False; if there is a category, set it to True. This means that each time
the subform moves to a new record the user can't enter data unless
there's a category already set.

Then put similar code in the AfterUpdate event of the category control,
so that when the user selects a category the other controls are enabled
ready to receive user input.
 
Back
Top