Predetermine subform size

  • Thread starter Thread starter Charles D Clayton Jr
  • Start date Start date
C

Charles D Clayton Jr

I have a main form that has a subform within it. The subform is used
to type employee names for an activity (which is the main form).
However, we are having some data input errors. For instances three
people were involved in an activity but only 1 or 2 of their names is
being entered. My question is this. Is it possible for me to insert
a text box that requests the number of people and then have that
answer automatically tell the subform to show me that number of
fields? This way the person entering the data has to think about the
answer ahead of time and will visually see if they are not entering
all the required people.

Thanks,

Charles D Clayton Jr
 
If this piece of info is that critical, you could make it a field in the
parent table. On the form, after the user enters a value into that field,
the subform could be hidden, locked, or disabled.

Otherwise, you could use the inputbox in the OnEnter property of the subform
control, but that's kind of hokey.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top