J
Jason Lopez
This is question two of my two question set.
How would I restrict the filling of information one control of a form based
on the information provided in another form control? Essentially, I have
working on a training form where organizational members cannot proceed to
the next batch of training modules until the first batch is complete. A
separate deparment tracks the individual modules and then updates the table
when the full batch of modules is complete. What I am trying to do is keep
someone from accidentally filling in the wrong control with information
unless it is in the proper sequence.
With each batch, I would like it to ripple through each batch control field
to verify if the control has been filled. Once it reaches a control that
has not been filled, then it opens that one up for filling and locks the
latter ones (at least until the current control is filled). I might be
getting in quite deep in the coding. But, it will help in the "After
Update" event that I have for the final batch date that is tied in to the
first question that I submitted of the two.
The only difference would be that on the last control field for the batch
dates, it would initiate a change in the image displayed on the main form.
All the training dates are on a subform.
I sincerely hope that I have not confused anyone. If so, let me know and I
will try to explain in more detail.
Jason Lopez
How would I restrict the filling of information one control of a form based
on the information provided in another form control? Essentially, I have
working on a training form where organizational members cannot proceed to
the next batch of training modules until the first batch is complete. A
separate deparment tracks the individual modules and then updates the table
when the full batch of modules is complete. What I am trying to do is keep
someone from accidentally filling in the wrong control with information
unless it is in the proper sequence.
With each batch, I would like it to ripple through each batch control field
to verify if the control has been filled. Once it reaches a control that
has not been filled, then it opens that one up for filling and locks the
latter ones (at least until the current control is filled). I might be
getting in quite deep in the coding. But, it will help in the "After
Update" event that I have for the final batch date that is tied in to the
first question that I submitted of the two.
The only difference would be that on the last control field for the batch
dates, it would initiate a change in the image displayed on the main form.
All the training dates are on a subform.
I sincerely hope that I have not confused anyone. If so, let me know and I
will try to explain in more detail.
Jason Lopez